Forum Discussion

cyncyn_98's avatar
cyncyn_98
Frequent Visitor
4 years ago
Solved

Subtracting Days using DAX Formula UTCNOW()

Hello everyone, 

 

Currently I'm working on a report that will refresh every Sunday. I have two tables that show two sets of data that report on different dates. Table 1 (Activity) reports on the Sunday where the data is refreshed, and Table 2 will report 7 days (one week) back from the refresh date. 

 

Below is the formula for the Activity Report date that will be refreshed every Sunday. 

 

Activity Thru Date = "Sunday, " & MONTH(UTCNOW()) & "/" & DAY(UTCNOW()) & "/" & YEAR(UTCNOW())
 
I have been trying to use the 'Date Add' function with no luck. 

 

Is there a way to subtract 7 days using the UTCNOW function for Table 2?
  • cyncyn_98 

     

    You can just add or minus Directly for days >>> 

    UTCNOW = UTCNOW()+2

    Today is 12 so it shows 14 there

     

    Regards,

    Ritesh

     

3 Replies

  • cyncyn_98 

     

    You can just add or minus Directly for days >>> 

    UTCNOW = UTCNOW()+2

    Today is 12 so it shows 14 there

     

    Regards,

    Ritesh