Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 137 | |
| 102 | |
| 68 | |
| 66 | |
| 64 |