Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have 2 slicers (Year month in French) + and Start week .
"Start and End of the month "defined by acccounting so for example first week of February starts on 2021/01/31....
I want on each opening of report set Month Year slicer to Max Value -1 (in March 2021 ,it should be February 2021) and Week start slicer to Last week of February (2021/02/21 )
Leaving user option to change Month Year and Week start later
Thank you
Solved! Go to Solution.
@Alex_G7 , You have create column like
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
and select last month, same way you have create for max week of last month and select that.
New column "Month Type" will have following presenation in "single selection" Slicer
"This Month"
"Last Month"
January 2021
December 2020
How to make sure that on opening of the report on slicer with "single selection"
"Last Month" will be already selected AND when client choose to use "drop down" all values bellow
will be listed in order to change selection
--------------
"This Month"
"Last Month"
January 2021
December 2020
Thank you
@Alex_G7 , You have create column like
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
and select last month, same way you have create for max week of last month and select that.
User | Count |
---|---|
66 | |
61 | |
47 | |
33 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |