when i select a month or two in slicer it should show previous 2 months based on my selection.

[Anonymous]

Hi All,

         Currently we have a metric called "PM" which is "Prior Month".  When a user selects 2 months, PM reflects the first month and the month before.  For example, selecting March + April, will cause PM on the metric card to reflect data for February + March. But i need January + February. Same when i select 3 months it should show previous 3 months dats.

[v-diye-msft]

Hi @Anonymous 

Do you mean if you select

1. Mar, then return Feb ?

2. Mar + Apr, then return Jan + Feb ?

3. Mar + Apr+ May, then return Last Dec + Jan + Feb ?

Please kindly share your dummy pbix or simple worksheet that would be easier for us to provide the valuable advice.

[amitchandak]

Are these months are continuous, or they can be discrete too?