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 need to do a slicer filter which will be the last month of the current moment and change automatically.
@Juanlfg06 , You can create a column like this in you date table/ table and use that
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Try : https://www.youtube.com/watch?v=hfn05preQYA
User | Count |
---|---|
69 | |
42 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
41 | |
39 | |
28 | |
24 |