Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi Guys,
Pretty new to PowerBi - I have a question on cumilative month data. I require a formula to pick up all the data depending on the month chosen for report below. Please let me know if any more information is required
Hi @Monir21 .
The solution depeds on your data and model. Do you have the data by month or by date? Do you want to show all months up to the current slicer selection or just the cumulative data up to the selected month, showing only the month selected in the slicer? Does the cumulative data reset at every year or add up?
As always, please post a sample data (not an image) and your expected result from that. I recomment to read through this stick post:
This is not the enough information. Please provide dummy data for input and desire result ss for output so that we can build the formula.
Regards,
sanalytics
User | Count |
---|---|
100 | |
66 | |
58 | |
47 | |
46 |