Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would be appreciated if you could help me to solve this issue.
What I would like to achieve is "Year and month filter needed to be automatically realize current year and month, and will select year or month filter by itself. We are not gonna select any month. Program must understand today's month and click filter."
As I know there is no way insert measure into filter.
Is there any way of measure or smt to implement that ?
Thanks in advance.
Regards
@kivancc94 , As of now, we can not default based on a measure. You have use a work around
Create a column and save that on This month in slicer
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |