Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Switch / IF

Hi,   Could I please double check if this is the right syntax to use, or should it be a switch statement?   test = IF( DATEDIFF(DATEADD(vw1[DateUpdated],-1, MONTH), vw1[CreatedDate], MONTH)...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Yeah, that syntax is fine, you don't have nested IF statements and not sure a SWITCH statement would make things much cleaner. Whether or not the code works, would need to see sample data to test. 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

The syntax looks right. Can you share if it is not working?

 

Thanks,

Pragati