Subtracting Days using DAX Formula UTCNOW()

[cyncyn_98]

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?

[ribisht17 · Accepted solution]

@cyncyn_98 

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

UTCNOW = UTCNOW()+2

Today is 12 so it shows 14 there

Regards,

Ritesh

[cyncyn_98]

Thanks! That worked perfectly!

[ribisht17]

Welcome 🙂