Forum Discussion

delmayhan's avatar
delmayhan
Frequent Visitor
3 years ago
Solved

Dateadd in previous Year

Hi all, i created a column of the current date = today()  and important to know today is 03/01/2023 What we do is taking a snapshot 10 days after each quarter. And from there on i create a co...
  • tamerj1's avatar
    tamerj1
    3 years ago

    delmayhan 
    Please try 

    Date of previous quarter = 
VAR CurrentDate = 'Issue snapshot'[Current Date]
VAR AdjustedDate = CurrentDate - 10
VAR Days = DAY ( AdjustedDate )
VAR PreviousDate = EOMONTH ( AdjustedDate, - 4 ) 
RETURN
    PreviousDate + Days
delmayhan's avatar
delmayhan
Frequent Visitor
3 years ago

Hi tamerj1 i expect the result ; Current date = Today() (03-01-2023 -10 days) = 24-12-2023 That is Q4 and then -1 quarter = Q3 So i Expect dates from Q3. Like 24-09-2022

 

You can test it yourself creating a column of today and then the above DAX formule, i expect data in the year 2022 but i get blank values back.

 

 

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

delmayhan 
Please try 

Date of previous quarter = 
VAR CurrentDate = 'Issue snapshot'[Current Date]
VAR AdjustedDate = CurrentDate - 10
VAR Days = DAY ( AdjustedDate )
VAR PreviousDate = EOMONTH ( AdjustedDate, - 4 ) 
RETURN
    PreviousDate + Days
  • delmayhan's avatar
    delmayhan
    Frequent Visitor
    3 years ago

    Thankyou tamerj1  it works!