Forum Discussion
Solved
Error while selecting alternate Quarters from Date slicer
I have Year, Month-Name, Date and Quarter-Name columns in Dim_Cal Table. I have used below DAX to get the value of previous period ---------------------------------------- Sales-Previous-Year=...
Hi swarajyadav24 ,
Perhaps you could try the EDATE function:
EDATE function (DAX) - DAX | Microsoft Learn
Best regards,
Community Support Team_ Scott Chang
Thank you for the quick response.
Do we have any other DAX function, which will provide same result as SAMEPERIODLASTYEAR does, At the same time, it should also work, when we click (Q1 and Q3) or (Q2 and Q4).
Hi swarajyadav24 ,
Perhaps you could try the EDATE function:
EDATE function (DAX) - DAX | Microsoft Learn
Best regards,
Community Support Team_ Scott Chang