Forum Discussion
CurrentMonth/PreviousMonth Parameter
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
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.
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
3 Replies
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.
Thanks Anonymous and Anonymous :) ..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" ) )
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
