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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Sum per month for 12 months

I have a Power BI report with Live feed from an Analysis service.   And i'm trying to solve the following issue purely with dax code in Power BI.  if it's not possible. It's okay to show how to make the calculated table via Summarize on the server.

I have a table with detailed invoice info(revenue).  This is then calculated in a simple measure  Sum(invoiced amount) this is then put into a simple table visual.  with the info Year, month, customer  info.   We would like to replace the measure, with a new one. Which should instead calculate the change between the months.    I have no problem in creating that. 


Change_Revenue = [Revenue] - CALCULATE([Revenue];PARALLELPERIOD(TimeTable[DateValue];-1;MONTH))

My problem is, i would like the measure to ONLY calculate the change per month.  But over the period of 12 months.  AND it's need to choose the last 12 months depending on the selected date/month  in the slicer of the same page.  in the end i will apply a top n filter on cust. level. to see the 20 biggest monthly improvements. I have tried illoustrating in the picture. That 1 customer can be on the list multiple times, since it's every single month change we are evaluating.
example.jpg

Hope it makes sense

 

1 REPLY 1
Anonymous
Not applicable

Really no one who can help?  

Open for alternative solutions, but would love to do it in power bi measure.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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