OrosPost Prodigy4 years agoSolvedIf, 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 ITEM REGULAR PRICE DISCOUNTED BANANA $5 APPLE $10 M...Show Morevojtechsima4 years agoHi, Oros as Column IF ( 'Table'[ISDISCOUNTED] = "YES", 1, 'Table'[REGULAR])
Shishir22Solution Sage4 years agoHello Oros , Add a calculated column-NewColumn = IF(Data[DISCOUNTED]="YES",1,Data[REGULAR PRICE]) Please mark it as answer if it resolves your issue. Kudos are also appreciated.
Related contentTranslate IF, ELSE IF, ELSE in DAX langageif then elseIF ELSE Logicif else conditionM Query - If Then Else
