Forum Discussion
JAVED
Helper I
Helper ICase statement in DAX
Hi Here i have a DAX Statement as CASE (WHEN stricker<>'' OR NONSTRIKER<>'' THEN (RUNS + (CASE WHEN BYES = 0 AND LEGBYES = 0 THEN OVERTHROW ELSE 0 END)) WHEN @BOWLER<>'' THEN (RUNS + WIDE+ (...
JAVEDHelper I
Helper IThank you prateekraina
JAVED,
As prateekraina's post, you would need to use Switch or if statement in DAX. If you have questions about the DAX, please share sample data of your tables and post expected result following the guide in this thread: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Regards,
Lydia