Forum Discussion

AlGrant's avatar
AlGrant
Frequent Visitor
2 years ago
Solved

Turn Dax calculated column into M formula for query editor

Hello,   I have a calculated column that I would like to recreate as a custom column in the query editor for the table 'CMI Application Tracker'   Overall Program Status = SWITCH (     TRUE(...
Need Help
Tips and Tricks
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi AlGrant ,

     

    Here's the basic IF statement structure in M to get you started:

    if [Migration Status] = "Complete" and [Decom Status] = "Complete" then "Complete"
else if [Migration Status] <> "Not Started" and [Decom Status] = "Not Started" then "In Progress"
...
...
else "Not Started"

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
2 years ago

Hi AlGrant ,

 

Here's the basic IF statement structure in M to get you started:

if [Migration Status] = "Complete" and [Decom Status] = "Complete" then "Complete"
else if [Migration Status] <> "Not Started" and [Decom Status] = "Not Started" then "In Progress"
...
...
else "Not Started"

 

Pete