Forum Discussion
Cumilative month formula
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
2 Replies
sanalyticsSuper User
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
- danextian
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:
