The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Really no one who can help?
Open for alternative solutions, but would love to do it in power bi measure.
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
10 | |
7 |