Forum Discussion
Month over Month
Hello!
I am trying to figure out why calculation to show previous month load volume is not adding correctly.
Currently the Formula I am using-
For Some reason It adds up the previous calculation instead of pulling only the last month value.
The table should read
blank, 510, 527, 843 etc.
Hi,@Csmith31
You can try the following methods:
1. Create a new date calculation column to calculate the actual time of the previous month of the current row.
Date = PARALLELPERIOD ( 'Table'[Mouth], -1, MONTH )2. Use the Date column to match the value that Last Mouth should display.
Last Month = CALCULATE ( MIN ( 'Table'[Load Volume] ), FILTER ( 'Table', 'Table'[Mouth] = EARLIER ( 'Table'[Date] ) ) )3. If you don't want to display the Date column, you can choose to hide it in the view.
Best Regards
Community Support Team _Charlottez Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous
pls try to add a calendar table and use DATEADD.
https://docs.microsoft.com/en-us/dax/dateadd-function-dax
Hi,@Csmith31
You can try the following methods:
1. Create a new date calculation column to calculate the actual time of the previous month of the current row.
Date = PARALLELPERIOD ( 'Table'[Mouth], -1, MONTH )2. Use the Date column to match the value that Last Mouth should display.
Last Month = CALCULATE ( MIN ( 'Table'[Load Volume] ), FILTER ( 'Table', 'Table'[Mouth] = EARLIER ( 'Table'[Date] ) ) )3. If you don't want to display the Date column, you can choose to hide it in the view.
Best Regards
Community Support Team _Charlottez Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
