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!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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?
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 54 | |
| 41 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 106 | |
| 99 | |
| 38 | |
| 29 | |
| 28 |