Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
98 | |
92 | |
38 | |
30 |