https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Dax-for-time-period/m-p/3059925#M105672 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="353897" data-lia-user-login="AlanP514" class="lia-mention lia-mention-user">AlanP514</a>&nbsp;,</P> <P>The value of a calculated column&nbsp;<SPAN>is computed during data refresh and uses the current row as a context; it<STRONG> does not</STRONG> depend on user interaction(slicer, filter etc.) in the report. The similar is true for the calculated table. So it can't achieve to create a dynamic column or table base on slicer selctions by creating a calculated column or calculated table... Please review the following blog, and check if that can used as an workaround.&nbsp;</SPAN></P> <P><A href="https://blog.enterprisedna.co/dynamic-date-slicer-in-power-bi-using-a-period-table/" target="_self"><SPAN>Dynamic Date Slicer In Power BI Using A Period Table</SPAN></A></P> <P><img /></P> <P><img /></P> <P>Best Regards</P> Fri, 03 Feb 2023 08:32:05 GMT Anonymous 2023-02-03T08:32:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Dax-for-time-period/m-p/3057739#M105541 <P>Hai All</P> <P><img /></P> <P>Here I am attaching the dummy pbi file also<BR /><BR />thanks<BR />Allen P</P> Thu, 02 Feb 2023 12:04:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Dax-for-time-period/m-p/3057739#M105541 AlanP514 2023-02-02T12:04:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Dax-for-time-period/m-p/3059925#M105672 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="353897" data-lia-user-login="AlanP514" class="lia-mention lia-mention-user">AlanP514</a>&nbsp;,</P> <P>The value of a calculated column&nbsp;<SPAN>is computed during data refresh and uses the current row as a context; it<STRONG> does not</STRONG> depend on user interaction(slicer, filter etc.) in the report. The similar is true for the calculated table. So it can't achieve to create a dynamic column or table base on slicer selctions by creating a calculated column or calculated table... Please review the following blog, and check if that can used as an workaround.&nbsp;</SPAN></P> <P><A href="https://blog.enterprisedna.co/dynamic-date-slicer-in-power-bi-using-a-period-table/" target="_self"><SPAN>Dynamic Date Slicer In Power BI Using A Period Table</SPAN></A></P> <P><img /></P> <P><img /></P> <P>Best Regards</P> Fri, 03 Feb 2023 08:32:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Dax-for-time-period/m-p/3059925#M105672 Anonymous 2023-02-03T08:32:05Z