Sum per month for 12 months

Anonymous — Tue, 01 Oct 2019 09:03:20 GMT

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.

Hope it makes sense

Re: Sum per month for 12 months

Anonymous — Mon, 07 Oct 2019 12:38:12 GMT

Really no one who can help?

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

topic Re: Sum per month for 12 months in DAX Commands and Tips

Sum per month for 12 months

Re: Sum per month for 12 months