Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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?
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 60 | |
| 52 | |
| 47 | |
| 40 | |
| 38 |