Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create label time intelligence

  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   ...
Need Help
rfigtree's avatar
rfigtree
Resolver III
5 years ago

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