topic My Previous Year Dax measure isn’t working in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Previous-Year-Dax-measure-isn-t-working/m-p/4619837#M176809 <P>Hello guys,i ran into a dax issue in my power bi,my previous year measure is giving blank after selecting each year slicer,my calendar table has been connected to my fact table,what could be the issue?</P><P>&nbsp;</P><P>Here is the pbix file for better understanding of the situation&nbsp;</P><P><A href="https://drive.google.com/file/d/1_PyR_0vPKOsvRybrulnyj4UIQ1dZnNgO/view?usp=drivesdk" target="_self">https://drive.google.com/file/d/1_PyR_0vPKOsvRybrulnyj4UIQ1dZnNgO/view?usp=drivesdk</A></P><P><img /></P><P> </P> Fri, 21 Mar 2025 12:13:35 GMT Diportee97 2025-03-21T12:13:35Z My Previous Year Dax measure isn’t working https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Previous-Year-Dax-measure-isn-t-working/m-p/4619837#M176809 <P>Hello guys,i ran into a dax issue in my power bi,my previous year measure is giving blank after selecting each year slicer,my calendar table has been connected to my fact table,what could be the issue?</P><P>&nbsp;</P><P>Here is the pbix file for better understanding of the situation&nbsp;</P><P><A href="https://drive.google.com/file/d/1_PyR_0vPKOsvRybrulnyj4UIQ1dZnNgO/view?usp=drivesdk" target="_self">https://drive.google.com/file/d/1_PyR_0vPKOsvRybrulnyj4UIQ1dZnNgO/view?usp=drivesdk</A></P><P><img /></P><P> </P> Fri, 21 Mar 2025 12:13:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Previous-Year-Dax-measure-isn-t-working/m-p/4619837#M176809 Diportee97 2025-03-21T12:13:35Z Re: My Previous Year Dax measure isn’t working https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Previous-Year-Dax-measure-isn-t-working/m-p/4619931#M176812 <P>Right click on the calendar table and choose mark as date table.</P> <P>By marking it as a date table, whenever you manipulate filters on the date column of the date table DAX automatically removes any other filters on the table, so you don't need to use REMOVEFILTERS.</P> Fri, 21 Mar 2025 13:26:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Previous-Year-Dax-measure-isn-t-working/m-p/4619931#M176812 johnt75 2025-03-21T13:26:32Z