https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-label-time-intelligence/m-p/1671067#M34170 <P>hi, calculated column.</P><P>didnt do exactly as you specified but you will get the concept.</P><LI-CODE lang="markup">=var _Today = TODAY() return SWITCH(TRUE(), Table1[date]=_Today,"Today", DATEDIFF(Table1[date],_Today,DAY)&lt;=30,"Last 30", "Other")</LI-CODE> Wed, 17 Feb 2021 08:40:22 GMT rfigtree 2021-02-17T08:40:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-label-time-intelligence/m-p/1670875#M34166 <P><img /></P><P>&nbsp;</P><P>Hi is it possible to do like table above ?</P><P>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&nbsp; only one measure</P><P>&nbsp;</P><P>Thank</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 Feb 2021 06:55:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-label-time-intelligence/m-p/1670875#M34166 Anonymous 2021-02-17T06:55:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-label-time-intelligence/m-p/1671067#M34170 <P>hi, calculated column.</P><P>didnt do exactly as you specified but you will get the concept.</P><LI-CODE lang="markup">=var _Today = TODAY() return SWITCH(TRUE(), Table1[date]=_Today,"Today", DATEDIFF(Table1[date],_Today,DAY)&lt;=30,"Last 30", "Other")</LI-CODE> Wed, 17 Feb 2021 08:40:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-label-time-intelligence/m-p/1671067#M34170 rfigtree 2021-02-17T08:40:22Z