showing total sales current month and within next 2 months

[crnswengineer]

As in the picture below, I want to show the total sales amounts to cover the current month and the next 2 months.

[crnswengineer]

hi @amitchandak 
i have tried the methods in the link that you share but i cant manage the get proper output. i prepared sample excel file that explains what i wanted. i hope it is understandable.
https://we.tl/t-so4QMowiJP

[amitchandak]

@crnswengineer , Based on what I got.

You May's data need on additional field 202205 and jun's need 202206 in one column . Means snapshot month.

Append both the tables

Now use Snapshot month and forecast month or row/column of matrix and build visual

[amitchandak · Accepted solution]

@crnswengineer , Check how to build this

Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Anal...

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.