topic Re: 7 Day Running Total and other DAX measures keeps returning an error in DAX Commands and Tips

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

MacJasem — Thu, 29 Sep 2022 08:36:14 GMT

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.

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

Greg_Deckler — Thu, 29 Sep 2022 08:55:50 GMT

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

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

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

MacJasem — Thu, 29 Sep 2022 09:33:14 GMT

Overthought that one without checking the formating - how embarrasing 😂

Thanks Greg_Deckler, much appreciated the swift reply!🙏

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

Greg_Deckler — Thu, 29 Sep 2022 09:35:11 GMT

MacJasem Happens!! 🙂

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

MacJasem — Tue, 04 Oct 2022 14:41:15 GMT

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]
)