Create label time intelligence

[Anonymous]

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

[rfigtree]

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")