how to use powerPivot to CALCULATE this month Deposit compare with previous month deposit

[Oscarr]

Hi,

how to use powerPivot to CALCULATE this month Deposit compare with previous month deposit?

Thanks

 

[GraH - Guido]

Your "day" should be a true date and not the day value for it to work.

FYI: Every date/time intelligence function requires real dates.

 

[Oscarr]

Your "day" should be a true date and not the day value for it to work.

FYI: Every date/time intelligence function requires real dates.

hi

don understand, can you use my sample file to make for me?

 

[GraH - Guido]

Oscarr, you should have real dates in your data.
I notices some strange entries:


Excel formula I used here: =0+(F2&"/"&LEFT(E2,3)&"/"&D2).

Please have a read on time intelligence in DAX:

PREVIOUSMONTH

Hi - I am having trouble with comparing date peiods and I really need direction. Please see my statement below. ShpdLast30 = CALCULATE (sum(InvoiceDetail[QtyShpd]), PREVIOUSMONTH(Dates[Date])) I don't understand the role of the Dates table & how the PREVIOUSMONTH function knows what...

community.powerbi.com

PREVIOUSMONTH function (DAX) - DAX

Learn more about: PREVIOUSMONTH

docs.microsoft.com

You should have a calendar table in your model too.

 

[Oscarr]

Oscarr, you should have real dates in your data.
I notices some strange entries:
View attachment 66641

Excel formula I used here: =0+(F2&"/"&LEFT(E2,3)&"/"&D2).

Please have a read on time intelligence in DAX:

PREVIOUSMONTH

Hi - I am having trouble with comparing date peiods and I really need direction. Please see my statement below. ShpdLast30 = CALCULATE (sum(InvoiceDetail[QtyShpd]), PREVIOUSMONTH(Dates[Date])) I don't understand the role of the Dates table & how the PREVIOUSMONTH function knows what...

community.powerbi.com

PREVIOUSMONTH function (DAX) - DAX

Learn more about: PREVIOUSMONTH

docs.microsoft.com

You should have a calendar table in your model too.

hi @GraH - Guido
Thanks Bro