https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Setting-Date-Context-in-CALCULATE-for-PREVIOUSQUARTER/m-p/1926630#M41789 <P>Hello, I need to set a date context of TODAY() within a CALCULATE function to properly have the PREVIOUSQUARTER evaluate what the previous quarter should be instead of taking the very first date of the Date Table.</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">Registrations Prev Qtr = CALCULATE(COUNT(Registration[Id]), PREVIOUSQUARTER(DimDate[Date]))</LI-CODE><P>&nbsp;</P><P>That is the DAX calculation right now. Then, I can apply a filter with the filter pane to set the "Date" to today for that specific visual. However, this breaks down when I need to use the measure above to create another measure to calculate a ratio with DIVIDE.&nbsp;</P> Mon, 28 Jun 2021 20:31:54 GMT crisher 2021-06-28T20:31:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Setting-Date-Context-in-CALCULATE-for-PREVIOUSQUARTER/m-p/1926630#M41789 <P>Hello, I need to set a date context of TODAY() within a CALCULATE function to properly have the PREVIOUSQUARTER evaluate what the previous quarter should be instead of taking the very first date of the Date Table.</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">Registrations Prev Qtr = CALCULATE(COUNT(Registration[Id]), PREVIOUSQUARTER(DimDate[Date]))</LI-CODE><P>&nbsp;</P><P>That is the DAX calculation right now. Then, I can apply a filter with the filter pane to set the "Date" to today for that specific visual. However, this breaks down when I need to use the measure above to create another measure to calculate a ratio with DIVIDE.&nbsp;</P> Mon, 28 Jun 2021 20:31:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Setting-Date-Context-in-CALCULATE-for-PREVIOUSQUARTER/m-p/1926630#M41789 crisher 2021-06-28T20:31:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Setting-Date-Context-in-CALCULATE-for-PREVIOUSQUARTER/m-p/1927261#M41807 <P>does this work?</P> <LI-CODE lang="markup">Registrations Prev Qtr = CALCULATE(CALCULATE(COUNT(Registration[Id]), PREVIOUSQUARTER(DimDate[Date])),DimDate[Date]=TODAY())</LI-CODE> Tue, 29 Jun 2021 06:32:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Setting-Date-Context-in-CALCULATE-for-PREVIOUSQUARTER/m-p/1927261#M41807 wdx223_Daniel 2021-06-29T06:32:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Setting-Date-Context-in-CALCULATE-for-PREVIOUSQUARTER/m-p/1927943#M41827 <P>It did indeed. Thank you!</P> Tue, 29 Jun 2021 10:08:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Setting-Date-Context-in-CALCULATE-for-PREVIOUSQUARTER/m-p/1927943#M41827 crisher 2021-06-29T10:08:12Z