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 is it possible to do like table above ?
I need to create a slicer for last day, last 30 days and last month for very month in all values in one table not only one measure
Thank
hi, calculated column.
didnt do exactly as you specified but you will get the concept.
=var _Today = TODAY()
return
SWITCH(TRUE(),
Table1[date]=_Today,"Today",
DATEDIFF(Table1[date],_Today,DAY)<=30,"Last 30",
"Other")
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |