Month over Month

[Anonymous]

Hello!

I am trying to figure out why calculation to show previous month load volume is not adding correctly. 

Last Month =

CALCULATE([Load Count],

PARALLELPERIOD(Table Name[Actual Delivery].[Date],-1,MONTH))

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.

[v-zhangti · Accepted solution]

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.

[ryan_mayu]

@Anonymous 

pls try to add a calendar table and use DATEADD.

https://docs.microsoft.com/en-us/dax/dateadd-function-dax