Forum Discussion
cyncyn_98
4 years agoFrequent Visitor
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?
You can just add or minus Directly for days >>>
UTCNOW = UTCNOW()+2Today is 12 so it shows 14 there
Regards,
Ritesh