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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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 |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 20 | |
| 11 |
| User | Count |
|---|---|
| 62 | |
| 55 | |
| 47 | |
| 44 | |
| 37 |