Forum Discussion
Trist
5 years agoFrequent Visitor
Case when in dax
Hi Everybody,
ı have question about case when statement in power bi. how to write below case when sql statement
in power bi?
SQL STATEMENT:
CASE WHEN D.DATEDIFFERENCE >= 0 AND D.SHKZG = 'S' THEN D.WRBTR * C.ExchangeRateValue_USD
WHEN D.DATEDIFFERENCE >= 0) AND SHKZG = 'H' THEN D.WRBTR * C.ExchangeRateValue_USD * -1
ELSE 0 END [Overdue (USD)]
Thanks,
1 Reply
- ERD
Community Champion
Hello Trist ,
There is a SWITCH function in DAX: SWITCH DAX Function.