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

1 Reply

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