Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm new to Power BI and hoping to get some guidance on a visual. I'm having difficulty creating a rolling month-by-month look at LTM Revenue.
For eaxample, if it's November 1, 2018 I'd like to see LTM data as of October 2018, September 2018, August 2018,...,December 2017, and November 2017.
I know I can create a slicer to see each month's LTM Revenue individually, but ideally I'd like to see all 12 months LTM Revenue in a single bar chart.
Is this even possible?
Solved! Go to Solution.
Wow I just created a video on this exact topic this morning... check it out on my YouTube channel!
https://www.youtube.com/watch?v=duMSovyosXE
Hope this helps,
Parker
Hi @mpranev,
I made one sample for your referece, If it doesn't meet your requirement, kindly share your sample data and excepted result to me. You can upload the files to onedrive and share the link here.
Here are the steps.
1. Create a date table.
Table2 = CALENDAR(DATE(2017,11,01),DATE(2018,11,30))
2. Create a measure as below.
Measure = var su = SUM('Table'[value]) return IF(ISBLANK(su),BLANK(),CALCULATE(SUM('Table'[value]),DATESINPERIOD(Table2[Date],LASTDATE('Table2'[Date]),-11,MONTH)))
For more details, please check the pbix as attached.
Regards,
Frank
Frank,
I really appreciate you taking the time to help answer my question. I've provided sample data to help illustrate.
I'm looking to get a rolling sum of values based on the Date Closed. Under the "Desired Output" table you can see the fees are pullind data for 12 months ending. Hopefully that makes sense.
Wow I just created a video on this exact topic this morning... check it out on my YouTube channel!
https://www.youtube.com/watch?v=duMSovyosXE
Hope this helps,
Parker
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
93 | |
84 | |
69 |