Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
66 | |
57 | |
49 | |
47 |