Forum Discussion

Trist's avatar
Trist
Frequent Visitor
5 years ago

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,