Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors