Forum Discussion

Sasha's avatar
Sasha
Icon for Helper III rankHelper III
7 years ago
Solved

DATEADD for moving Quarters

Hi, Recently I needed to compare "moving" quarters (noit calendric), i.e: comparing March-May to December-February. All my measures were built in the way of DATEADD(x, -1, QUARTER), and I was wonde...
Need Help
  • OwenAuger's avatar
    OwenAuger
    7 years ago

    Hi Sasha 

    As far as I can tell from testing, those two expressions are interchangeable.

     

    So for the purpose of DATEADD, a quarter is just shorthand for 3 months, and DATEADD doesn't apply any logic to do with aligning with quarters of a calendar year.

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
7 years ago

Hi Sasha 

As far as I can tell from testing, those two expressions are interchangeable.

 

So for the purpose of DATEADD, a quarter is just shorthand for 3 months, and DATEADD doesn't apply any logic to do with aligning with quarters of a calendar year.