Forum Discussion

jen8080's avatar
jen8080
Helper I
5 years ago
Solved

Excel IFS to DAX

Hello- I have this formula in my current excel report  =@IFS(Y3="","Missing Complete Date",(Y3-W3)<0,"On Time",(Y3-W3)=0,"On Time",(Y3-W3)>0,"Missed")   I need to translate into DAX and keep runn...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this calculated column formula

    =if(data[actual complete date]=blank(),"Missing Complete Date",if(data[target date]>=data[actual complete date],"On time","Missed"))

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

=@IFS(Y3="","Missing Complete Date",(Y3-W3)<0,"On Time",(Y3-W3)=0,"On Time",(Y3-W3)>0,"Missed")

Hi jen8080 

Try

SWITCH(TRUE(),
        Y3="","Missing Complete Date",
       (Y3-W3)<0,"On Time",
       (Y3-W3)=0,"On Time",
       (Y3-W3)>0,"Missed")
jen8080's avatar
jen8080
Helper I
5 years ago

Hello- I tried this and get the 'DAC Comparison opertations do not support comparing calues of type Date with Values of type text'.