How to set up Power Pivot: Measures for Orders > Current Mth

[KimC2504]

Hi There,
I am rebuilding my Power Pivot data tables and hoping to do it better 2nd time round.
I have several similiar measures
eg, calculate(sum('Sales Funnel'[USD]),'Date'[Month#]>8)
Each month i manually change the month on the measures.

Is it possible to set up a parameter table which you update the current month once instead of manually updating each of the measures? How can this be done?

Any suggestions would be appreciated

 

[scottsen]

Likely you want to add some sort of column to your Date table... IsCurrentMonth or IsLastMeasurementMonth or... something that you can use in your measure, that magicaly updates each refresh.

 

[KimC2504]

Hi Scottsen,
I feel stupid asking the question now as such a simple solution however it never occurred to me to do that.

THanks for the response