Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
As in the picture below, I want to show the total sales amounts to cover the current month and the next 2 months.
Solved! Go to Solution.
@Anonymous , 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-Analysis/ba-p/1393410
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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
@Anonymous , 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
@Anonymous , 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-Analysis/ba-p/1393410
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
12 | |
12 | |
9 |
User | Count |
---|---|
63 | |
22 | |
21 | |
17 | |
11 |