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
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi delmayhan 

can you please provide the expected results?

  • 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!