I am having issues while creating new column "Shipping Status" with below logic.
Relationship --> A given project contains multiple tasks. Any help will be much appreciated.
Go to Solution.
Please try the below for creating a new column.
Shipping Status Column =VAR currentproject = 'Table'[Project ]VAR shippingtaskid =CALCULATE (SELECTEDVALUE ( 'Table'[Task Id] ),FILTER (ALL ( 'Table' ),'Table'[Project ] = currentproject&& 'Table'[Task Name] = "Shipping"))RETURNSWITCH (TRUE (),'Table'[Task Id] < shippingtaskid&& 'Table'[Project ] = currentproject, "Pre-Shipping",'Table'[Task Id] > shippingtaskid&& 'Table'[Project ] = currentproject, "Post-Shipping","Shipping")
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
View solution in original post
Hi @Jihwan_Kim ,Thank you very much for the suggestion, it works exactly the way I wanted 🙂
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.