Values replicating over months in Matrix

[PBrainNWH]

What can I look for to fix this issue where my July numbers are replicating in each of the subsequent months?

[v-heq-msft · Accepted solution]

Hi @PBrainNWH ,
Based on your description, your data carried out a duplicate after July. This may be due to the fact that the data was not filtered in the context of columns, only rows were applied. So the aggregation was done with row categorization. If Actual is a measure, you can use calculate and alexcept to sort by month.
The above is speculation based on the screenshot you provided, if you want to get more detailed help, you can provide example data, preferably a pbix file. Please hide sensitive information in advance.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly