CurrentMonth/PreviousMonth Parameter

[ShashidharG]

Can you guys suggest me on???

The Parameter Selection option for the users showing

1. Current Month

2. Previous Month

selections, as data filtering on the dashboard Charts.

like Net sales, Budget sales,.. data for current or previous months on selection

[Anonymous · Accepted solution]

Probably the easiest way to do this is by modify your Calendar table to have a calc column where rows that in the current month are labeled "Current Month" and rows in the prior month are labeled "Previous Month", and others are labeled something like "Older".

If you then put that on a slicer... you will have   { Current, Previous, Older } and when nothing is selected... you will get all data.

[v-shex-msft · Accepted solution]

Hi @ShashidharG,

I agree with scottsen's point of view, I share the sample formula, perhaps you can refer to it:

Check Date= if([Date].[Year]=YEAR(TODAY()),SWITCH([Date].[MonthNo],MONTH(TODAY()),"Current Month",MONTH(TODAY())-1,"Previous Month","Other"),"Other")

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Probably the easiest way to do this is by modify your Calendar table to have a calc column where rows that in the current month are labeled "Current Month" and rows in the prior month are labeled "Previous Month", and others are labeled something like "Older".

If you then put that on a slicer... you will have   { Current, Previous, Older } and when nothing is selected... you will get all data.

[ShashidharG]

Thanks @Anonymous and @v-shex-msft 🙂 ..That's two best approaches and worked !!! 

tried with slicer using-

TimePeriod = IF(MONTH(SalesHist[BillDate])=MONTH(TODAY()) && YEAR(SalesHist[BillDate])=YEAR(TODAY()) , "CurrentMonth", IF(MONTH(SalesHist[BillDate])=(MONTH(TODAY())-1) && YEAR(SalesHist[BillDate])=YEAR(TODAY()), "PreviousMonth","Older" ) )