Forum Discussion
Help with complex measure for Matrix Visual
I have a complex matrix visual requirement that I'm struggling with. I have managed to solve it using a calculated table but this has limitations that a solution using measures would not have. Can ...
mikemagill Is the B Z row in the original data supposed to have an ID of 2?
No. I have deliberately included a third ID (3) to show that there could be cost allocated to IDs in the earlier month that don't exist in the later month.
Therefore, the 600 is Nov-23 is made up of 100 from ID2 and 500 from ID3.
Does that make sense?