Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Solved! Go to 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])
)
)
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]
)
@MacJasem Missed a closing paren: ALL('Date'),
7DayRunningTotal =
CALCULATE(
[SalesValue],
FILTER(
ALL('Date'),
'Date'[Date] > MAX('Date'[Date]) - 7 && 'Date'[Date] <= MAX('Date'[Date])
)
)
Overthought that one without checking the formating - how embarrasing 😂
Thanks @Greg_Deckler, much appreciated the swift reply!🙏
@MacJasem Happens!! 🙂
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!