GET Current vs Last Month values from an aggregated measure.

[Anonymous]

I have a Credit measure that is calculated like X/Y. And I also have a hierarchy calendar table...

I want to compare The credit measure for this month vs last month dynamically or if not possible with a slicer to choose a month and compare to the previous one

Is it possible to accomplish?

Thank you in advance!

[PVO3]

Yes there are a number of time intelligence functions. 

You can try something like this.

CALCULATE([Credit measure], PREVIOUSMONTH(date[date])

[Anonymous]

I'ts returning blank values. 

[PVO3]

Did you select a month?

[Anonymous]

Yes

[PVO3]

It should work when using your date slicer. 

- Do you have a date table?

- Is it marked as a date table?

But it's hard to guess, so please send a sample file, screenshots of model & visuals.