Forum Discussion
Solved
Calculate Text value based on date in another column
Softball question for some of the experts out there... I have a column titled "Due Date" that tells me when a specific action item will be completed by. I want to calculate a "Phase" column t...
tmitton - Seems like:
Phase = SWITCH(TRUE(), [Date] <= DATE(2020,6,30),"Phase 1", [Date] > DATE(2020,6,30) && [Date] <= DATE(2020,9,30),"Phase 2", [Date] > DATE(2020,10,1) && [Date] <= DATE(2020,12,31),"Phase 3", "N/A" )
tmitton - Seems like:
Phase =
SWITCH(TRUE(),
[Date] <= DATE(2020,6,30),"Phase 1",
[Date] > DATE(2020,6,30) && [Date] <= DATE(2020,9,30),"Phase 2",
[Date] > DATE(2020,10,1) && [Date] <= DATE(2020,12,31),"Phase 3",
"N/A"
)This returns the following error:
It had me remove one of the double "&" keys, and then told me that "SWTICH" is not recognized.
Thanks again for any guidance you can provide.
tmitton
You are supposed to use Greg_Deckler 's solution as a new column in your table in the Power BI Data Model. not in Power Query.
Select the table and________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
