Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I am trying to build a visual table where the columns will be:
YearMonth Amount MTD PreviousMTD Variation between MTD/PMTD
There are daily transactions coming in. The goal is to be able to compare, on a same day of the month, the overall variation and see how it evolves on a daily basis. Eg. compare the MTD on Dec 10, vs. what was the MTD on Nov 10, Oct, 10 and so on.
Looking at different posts I am able to correctly get the MTD with this measure:
Solved! Go to Solution.
Hi @mwegener ,
Thanks so much for the quick and detailed answers, really appreciated! I was actually able to make it work by using your PMTD measure, but combined with my original MTD measure as in the original post. So the measure looks like this:
So as a result, it's now possible to show in the same table the total amount, the MTD, the PMTD, and the variance between the two. Screen capture below. This way, on each day of the month, you can see how you're trending vs. the same day last month.
Hi @ebeauchamp ,
check this out.
MTD =
TOTALMTD(SUM(Orders[Amount]), Dates[Date])
PMTD =
TOTALMTD(SUM(Orders[Amount]), DATEADD(Dates[Date],-1,MONTH))
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @mwegener ,
Thanks so much for the quick and detailed answers, really appreciated! I was actually able to make it work by using your PMTD measure, but combined with my original MTD measure as in the original post. So the measure looks like this:
So as a result, it's now possible to show in the same table the total amount, the MTD, the PMTD, and the variance between the two. Screen capture below. This way, on each day of the month, you can see how you're trending vs. the same day last month.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @ebeauchamp ,
1. Take a look at the Quickmeasure MTD
https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
2. Take a look at relative date slicer and filter, to filter the visual on today
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
3. Take a look at PARALLELPERIOD DAX Funktion
https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |