matrix - one date to be presented in matrix row, but sum related to different month

[chewoo]

Hi,

I want to do next:

I one to present matrix, with buckets as columns and months as rows.

For Feb and bucket 2, I need to present sum amount for all account that were in bucket 2, two months after feb(april), but they were in bucket 1 one month later (march)

Regards,

Thanks

[v-chuncz-msft]

@chewoo,

Try using CALCULATE Function to change the context.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/

[chewoo]

@v-chuncz-msft

Thanks for fast reply,

This is something like migration matrix, I need to see how much amount rolled from one month to next month from one bucket to another.

For February, I got 1000 USD in bucket 0 for example, and I need to present in same row in column 1 how much money rolled frow bucket 0 to bucket 1 in March.

thanks