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.

     

Ritaf1983's avatar
Ritaf1983
Super User
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.