Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |