Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!