Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |