DAX - Variable for exact date in Previous Quarter

[balafbm]

Hi,

I have defined a variable in dax.

VAR X = DATE(2023,02,10)

I want to create another variable "Y", which would return the exact date one quarter ago.

I am unable to find a function which would return that. Any help will be appreciated.

[HassanAshas]

You can try EDATE 

Var Y = EDATE([VAR X], -3)

Since a Quarter is always 3 months back, so we can go 3 months back using EDATE. 

[FreemanZ]

hi @balafbm 

try like:

VAR Y=EDATE(X, -3)