7 Day Running Total and other DAX measures keeps returning an error

[MacJasem]

Hi Guys

I've experienced that I seem to have an issue with writing Dax measures. I keep getting errors when refering to table Columns.

What am i doing wrong? is there a setting that i have to change somewhere?

7DayRunningTotal = CALCULATE( [SalesValue],

FILTER(ALL('Date', 'Date'[Date] > MAX('Date'[Date]) - 7 && 'Date'[Date] <= MAX('Date'[Date]))))

as I find inspiration from other Dax measures shared on the net I see the reference to Tables is different in my case with the '' around the table, whereas I dont see this in other peoples DAX examples.

[MacJasem]

Hi @Greg_Deckler 

I got inspiration from your colleague Sam McKay (Enterprise DNA) with regards to calculating previous week sales:

This time I even used DaxFormatter to make sure nothing was missed, and the formatting came out fine, but i still got this error in PowerBI. Couldn't really figure out what the issue is. Any idea?

PreviousWeekSales =
VAR CurrentWeek =
SELECTEDVALUE ( 'Date'[Week Number] )
VAR CurrentYear =
SELECTEDVALUE ( 'Date'[Year] )
VAR MaxWeekNumber =
CALCULATE ( MAX ( 'Date'[Week Number] ), ALL ( 'Date' ) )
RETURN
SUMX (
FILTER (
ALL ( 'Date' ),
IF (
CurrentWeek = 1,
Date[Week Number] = MaxWeekNumber
&& 'Date'[Year] = CurrentYear - 1,
Date[Week Number] = CurrentWeek - 1
&& 'Date'[Year] = CurrentYear
)
),
[SalesValue]
)

[Greg_Deckler · Accepted solution]

@MacJasem Missed a closing paren: ALL('Date'), 

7DayRunningTotal = 
CALCULATE( 
  [SalesValue],
  FILTER(
    ALL('Date'), 
    'Date'[Date] > MAX('Date'[Date]) - 7 && 'Date'[Date] <= MAX('Date'[Date])
  )
)

[MacJasem]

 Overthought that one without checking the formating - how embarrasing 😂

Thanks @Greg_Deckler, much appreciated the swift reply!🙏

[Greg_Deckler]

@MacJasem Happens!! 🙂