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
vmkumar1
Frequent Visitor

IF logical Fucntion

Hi All,

 

I am new to DAX coding. Could you please help me in understanding below function? Thanks .

 

I am using a IF(OR( Column1 = "X","Y","A","B")) logic in excel to compare my column1 values.

When I tried the same logic in PowerBi measure, I wont see my column name at all, IF(OR())

Could you please help me by explaining what am I mssing here? Thanks.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

 

Here is the syntax for IF with multiple values . Hope this helps to you.

 

Column = IF(Detais[Category] IN {"AA", "AB","BA"} , 1,2)
 
Thanks
Raj

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

 

Here is the syntax for IF with multiple values . Hope this helps to you.

 

Column = IF(Detais[Category] IN {"AA", "AB","BA"} , 1,2)
 
Thanks
Raj

Thanks for the reply Rajendran.

When to use a Measure or Conditional Coulumn?

Do u mind helping me to undersatnd when to use Calculate or Filter function?

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.