calculation of a custom previous period

[Anonymous]

hi all

i've been through the forums, but unfortunately haven't found any help to my case.

i need to calculate a metric which calculates the previous period vs the calendar date selected.

let's say I have Nov-Dec18 selected, I have a metric1 showing those figures, I'd need to have also another metric2 showing the figures for Sep-Oct.

Better to have at a month granularity level.

I'm not sure how to figure it out, also because with calendar selection affects both the metric1 & 2.

can anyone help please?

thanks in advance!

ps here the example

https://drive.google.com/file/d/17RKjDfEzDvvffkh9LePtZfIKyzhAuoWa/view?usp=sharing

[v-cherch-msft]

Hi @Anonymous

You may refer to below articles about how to calculate last 2 months and 5 days sales based on slicer selection.You may try the same work around to calculate last 2 months or last 60 days values.

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...
https://www.kasperonbi.com/show-the-sum-of-sales-for-the-last-3-days-based-on-date-selection/

Regards,

Cherie

[Anonymous]

@v-cherch-msft & @Greg_Deckler

thanks for your reply.

however I haven't reach a conclusion yet. Below a formula for the metric I need. if I select from the calendar filter ie. 13-15 dec, I expect this metric counts data only for 10-12 dec. 

I'm going on working on this, meanwhile any help is much appreciated.

best,

[v-cherch-msft]

Hi @Anonymous

Please check the attached file.

Regards,

Cherie

[Greg_Deckler]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...