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 :
Phase 1 =
var Phase_1_value = if(Aggregate_view[Phases]="Phase 1",(Aggregate_view[Phase_done_progress]),BLANK())
Is there any way instead of having BLANK put the same result according to the PHASE ?
P.S. I know that there is a default transpose function in query and I am enforced to do in DAX.