Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Case when

Hi all please how would I write this below statement in DAX, been trying to convert this SQL query but I keep getting an error    SQL Script    COALESCE(SUM(CASE WHEN ((CASE WHEN X THEN 1 ELSE 0 ...
General Comment
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Correct the condition X<>  0

     

     

    Sumx(Table, if( if([X] <>0, 1,0)=0 && not(isblank([Y])) , datediff([d1], [d2],minute)/60,blank()))

     

    This should be a measure

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Correct the condition X<>  0

 

 

Sumx(Table, if( if([X] <>0, 1,0)=0 && not(isblank([Y])) , datediff([d1], [d2],minute)/60,blank()))

 

This should be a measure