Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
crnswengineer
Frequent Visitor

showing total sales current month and within next 2 months

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

crnswengineer_0-1658904487506.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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.

View solution in original post

3 REPLIES 3
crnswengineer
Frequent Visitor

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

@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
Super User
Super User

@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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.