Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.