Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |