Converting SQL CASE Statement Into a DAX Measure

Anything related to PowerPivot and DAX Formuale
Siva
Posts: 1
Joined: Wed Jul 08, 2020 11:45 am

Re: Converting SQL CASE Statement Into a DAX Measure

Postby Siva » Wed Jul 08, 2020 11:54 am

]Hi ,
I have a scenario to convert SQL Query logic into DAX.

[color=#804040][/color]
[b]Case when product.product_name in (‘Prod1’, ‘Prod2’, ‘Prod3’, ‘Prod4’, ‘Prod5’) then sales.Qty else 0 end[/b]

As I am a beginner to PowerBI and DAX, I am not sure how to Convert into DAX.

Any help will be appreciated.

Thanks,
Siva


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests