Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
How to display current year and month to be selected in the slicer (i.e. would automatically open on the current month at all times).
Solved! Go to Solution.
@Umadhandapani , There is only work around for that
Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
Month Type = Switch( True(),
month([Date])= month(Today()),"This Month" ,
month([Date]) & ""
)
or
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" ,
Date([Date])= eomonth(Today(),0),"This Month" ,
[Month]
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
You need save value like this year, this month
@Umadhandapani , There is only work around for that
Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
Month Type = Switch( True(),
month([Date])= month(Today()),"This Month" ,
month([Date]) & ""
)
or
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" ,
Date([Date])= eomonth(Today(),0),"This Month" ,
[Month]
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
You need save value like this year, this month
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |