I have this table in my model:
and I need to get this result table:
Is there any chance to achieve this through DAX?
Thank you for your time.
Go to Solution.
Nope, dax is impossible to achieve this.In my opinion, you can use original table column to create matrix visual with same result.
View solution in original post
Visual is fine but need this as intermediate table for calculations...(also unlock dynamic column selection!).
Why is this so hard? I am trying to get away from excel but some things like this are a huge nuisance to quick transfer of existing reports.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.