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 ...
Sorry, my example table was wrong - It's been a long week and it's only Monday!
| Cost | Cost | ||
| Contract | Band | 30/06/2024 | 30/11/2023 |
| A | X | 110.00 | 750.00 |
| B | Y | 1,050.00 | 600.00 |
| B | Z | ||
| C | Z |
Does that make more sense now? Thanks for reaching out.
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?