topic Re: Dax formual for Date-1 in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formual-for-Date-1/m-p/2161474#M49972 <P>Thanks..!</P> Thu, 28 Oct 2021 17:47:20 GMT Anonymous 2021-10-28T17:47:20Z Dax formual for Date-1 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formual-for-Date-1/m-p/2161352#M49964 <P>Hi,</P><P>&nbsp;</P><P>I want to add an extra column with Date-1 for the below load date, could someone help me with DAX formula.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 28 Oct 2021 16:45:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formual-for-Date-1/m-p/2161352#M49964 Anonymous 2021-10-28T16:45:38Z Re: Dax formual for Date-1 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formual-for-Date-1/m-p/2161455#M49971 <P>Anonymous</LI-USER>&nbsp;So:</P> <LI-CODE lang="markup">Column = [Load Date] - 1</LI-CODE> Thu, 28 Oct 2021 17:40:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formual-for-Date-1/m-p/2161455#M49971 Greg_Deckler 2021-10-28T17:40:10Z Re: Dax formual for Date-1 https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formual-for-Date-1/m-p/2161474#M49972 <P>Thanks..!</P> Thu, 28 Oct 2021 17:47:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formual-for-Date-1/m-p/2161474#M49972 Anonymous 2021-10-28T17:47:20Z