cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Measure If Statement based on Text Column

I would like to create a Measure that I can use an If statement based on a column that is Text-based. Essentially I want something that can tell me based on what the Current Phase is, if something is overdue. 

 

For Example for Project ID #11, since the current phase is DP-C, I would want DP-A and DP-B to show blank in the overdue column, but would want DP-C to show overdue because that Actual Date is < today. However, I can't even get my "Current Phase" column (which is in another table [PP-Project Status]) to show up in my list of columns I can pull into an if statement. Do I have my relationships set up incorrectly?

 

enswitzer_1-1602084371312.png

 

 

1 REPLY 1
Resolver II
Resolver II

Create  Current Phase in the  Proejct ID table  using   CurrentPhase = RELATED(PP-Project Status. [CurrentPhase]) and  the you can pull in to  your  if statment .

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors