Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Hi PowerBI users,
I would like to find out whether is possible to transpose rows into columns against Phases field. I have already prepared a intial logic however I still missing to populate the rest of the records which basically they do not meet the conditions :
So in the end I would like repeat blank values with the same value even though it is not a correnspoding phase. The logic for Phase 1 for example is :
Solved! Go to Solution.
Hi, @Jaromac
You don't need to use 'if' statement at all. To replace the blank, you just need to change the code as below:
Calculated columns:
Phase_1 =
CALCULATE (
MAX ( Aggregate_view[Phase_done_progress] ),
FILTER ( Aggregate_view, Aggregate_view[Phases] = "Phase 1" )
)
Phase_2 =
CALCULATE (
MAX ( Aggregate_view[Phase_done_progress] ),
FILTER ( Aggregate_view, Aggregate_view[Phases] = "Phase 2" )
)
Phase_3 =
CALCULATE (
MAX ( Aggregate_view[Phase_done_progress] ),
FILTER ( Aggregate_view, Aggregate_view[Phases] = "Phase 3" )
)
Best Regards,
Community Support Team _ Eason
Are those "Phase_done_progress" numbers always the same for each phase?
For instance, the Phase 2 is always 97%?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Yes 🙂 In the end I have a another column which reduce those numbers of records to have only one value but firstly I need to populate all blank records.
Hi, @Jaromac
You don't need to use 'if' statement at all. To replace the blank, you just need to change the code as below:
Calculated columns:
Phase_1 =
CALCULATE (
MAX ( Aggregate_view[Phase_done_progress] ),
FILTER ( Aggregate_view, Aggregate_view[Phases] = "Phase 1" )
)
Phase_2 =
CALCULATE (
MAX ( Aggregate_view[Phase_done_progress] ),
FILTER ( Aggregate_view, Aggregate_view[Phases] = "Phase 2" )
)
Phase_3 =
CALCULATE (
MAX ( Aggregate_view[Phase_done_progress] ),
FILTER ( Aggregate_view, Aggregate_view[Phases] = "Phase 3" )
)
Best Regards,
Community Support Team _ Eason
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
18 | |
14 | |
11 | |
10 | |
9 |