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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Monir21
New Member

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 

 

Monir21_1-1725776502956.png

 

 

 

2 REPLIES 2
danextian
Super User
Super User

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:

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
sanalytics
Super User
Super User

@Monir21 

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

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors