Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

IF or Switch

Hi good day can anyone assist me on my query. I have table, I want the Stutus "Not Startted" if the date is in coming or in futere "Delayed" if the date already pass on the end date and the progres...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi AllanBerces 
    You can create a calculated column with the dax :

    Status =
    if('Table'[Remarks]=1,"Completed",
    If ([P1 Sta]>=TODAY(),"Not started",
    if ('Table'[Remarks]<1 && 'Table'[P1 En]<TODAY(),"Delayed",
    if('Table'[Remarks]<1 &&'Table'[P1 En]>=TODAY(), "In progress")
    )))

    The pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

Chakravarthy's avatar
Chakravarthy
Resolver II
2 years ago

Hi AllanBerces 
Try this Code

 

Status =
VAR _START = 'Table'[P1 Start]
VAR _END = 'Table'[P1 End]
VAR _PRO = 'Table'[Remarks]
VAR _Result =
SWITCH(TRUE(),
_START>=TODAY(),"Not Started",
_PRO=1 && _END<=TODAY(),"Completed",
_PRO<1 && _END<TODAY(),"Delayed",
_PRO<1 && _END>=TODAY(),"In-Progress",
"NO STATUS UPDATE"
)

RETURN _Result