Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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?
User | Count |
---|---|
84 | |
78 | |
70 | |
46 | |
42 |
User | Count |
---|---|
106 | |
50 | |
49 | |
40 | |
40 |