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
Oros
Post Patron
Post Patron

If, else

Hello,

 

I have this 1 table that I would like to create an IF, ELSE column (or a measure) to replace the REGULAR PRICE

 

ITEMREGULAR PRICEDISCOUNTED
BANANA$5 
APPLE$10 
MANGO$20 

 

If discounted=YES, then the price column becomes $1.  If discounted=NO, then regular price.

 

Thanks.

 

1 ACCEPTED SOLUTION
vojtechsima
Memorable Member
Memorable Member

Hi, @Oros 
as Column 

IF ( 'Table'[ISDISCOUNTED] = "YES", 1, 'Table'[REGULAR])

View solution in original post

5 REPLIES 5
Oros
Post Patron
Post Patron

Hello @vojtechsima ,

 

Thanks for the prompt reply.  I get an error message.  (DAX comparison operations do not support comparing values of type True?False with values of type Text.)

Oros_0-1653405560995.png

 

Hi, @Oros ,
Make sure your columns are in proper data types, when comparing string ("YES", "NO") the column has to be a text, if numeric values (1,2) it has to be Numeric. PLease check that and try running itagain

Hello @vojtechsima ,

 

I change it to text but got another error:

 

"Expressions that yield variant data-type cannot be used to define calculated columns."

 

Any idea?

 

Thanks.

Shishir22
Solution Sage
Solution Sage

Hello @Oros , 

 

Add a calculated column-

NewColumn = IF(Data[DISCOUNTED]="YES",1,Data[REGULAR PRICE])

 

Shishir22_0-1653404834370.png

 

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

 

 

Cheers,
Shishir
vojtechsima
Memorable Member
Memorable Member

Hi, @Oros 
as Column 

IF ( 'Table'[ISDISCOUNTED] = "YES", 1, 'Table'[REGULAR])

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.