Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Solved! Go to Solution.
hi, @Anonymous
I'm afraid it is difficult achieve in DAX, this has changed table structure. and unless you use use a matrix visual to show the result and do not show current value in visual.
here is the pbix file, please try it.
Best Regards,
Lin
hi, @Anonymous
Your expected output is a bit messy, and if I understand you correctly, you could try this way as below:
First add a current status column
In Edit Queries, Duplicate the basic table use Group by and merge function like this post.
Second use Pivot column function like below:
Select Status column and then click Transform->Pivot column
Result:
and here is pbix file, please try it.
By the way, you could change another browser eg. IE, It will be well.
Best Regards,
Lin
Love it!! Can this be done in DAX?
hi, @Anonymous
I'm afraid it is difficult achieve in DAX, this has changed table structure. and unless you use use a matrix visual to show the result and do not show current value in visual.
here is the pbix file, please try it.
Best Regards,
Lin
Love it!! Can this be done in DAX?