cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KirbyAlexander
New Member

Retrieving information rom within a field.

I have 5 different columns that I need to extract infomation from and put the results in one column.  The following is what I have written to accomplish this, but it is not working.  Can anyone tell me what I am doing wrong?

 

AFR = IF(ISNUMBER(SEARCH("AFR",[Title])),"Y",IF(ISNUMBER(SEARCH("AFR”,[Finance Approve?])),"Y",IF(ISNUMBER(SEARCH("AFR",[Notes])),"Y",IF(ISNUMBER(SEARCH("AFR",[Notes_ 1])),"Y",IF(ISNUMBER(SEARCH("AFR",[Declined Reason])),"Y",IF(ISNUMBER(SEARCH("AFR",[Construction Request Type])),"Y","N"))))))
 
Any help woud be great.  Thanks.
1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

Hi,

I guess you are trying to check if one of these 5 columns include "AFR"? 

Try using this kind of logic:

Dax:

Column = IF(
    countrows(FILTER('Table',OR(EARLIER('Table'[Value])=10,EARLIER('Table'[Name])="o"))
    )>=1,"y","n")

End result:

ValtteriN_0-1659682293102.png



This Dax tests if a [Value] in a table contains value 10 or [name] = "O". By using this logic you could create something like 

 

Column = IF(
    countrows(FILTER('Table',OR(
EARLIER('Table'[C1])="AFR",
EARLIER('Table'[C2])="AFR"),
EARLIER('Table'[C3])="AFR",
EARLIER('Table'[C4])="AFR"),
EARLIER('Table'[C5])="AFR"))
    )>=1,"y","n")


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
KirbyAlexander
New Member

What you provided gave me the bases for what I was trying to do.  Thank you.

ValtteriN
Super User
Super User

Hi,

I guess you are trying to check if one of these 5 columns include "AFR"? 

Try using this kind of logic:

Dax:

Column = IF(
    countrows(FILTER('Table',OR(EARLIER('Table'[Value])=10,EARLIER('Table'[Name])="o"))
    )>=1,"y","n")

End result:

ValtteriN_0-1659682293102.png



This Dax tests if a [Value] in a table contains value 10 or [name] = "O". By using this logic you could create something like 

 

Column = IF(
    countrows(FILTER('Table',OR(
EARLIER('Table'[C1])="AFR",
EARLIER('Table'[C2])="AFR"),
EARLIER('Table'[C3])="AFR",
EARLIER('Table'[C4])="AFR"),
EARLIER('Table'[C5])="AFR"))
    )>=1,"y","n")


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors