@@havenscr I have also got A result of $0 for my six-month trend. is there a common error that makes this occur Sales Amount 6 month trend = VAR LastSaleDate = LASTDATE ('Turnover YTD'[Project Invoiced Date]) RETURN AVERAGEX ( DATESBETWEEN ( 'Turnover YTD'[Project Invoiced Date], DATEADD(STARTOFMONTH(LastSaleDate), -5, MONTH), ENDOFMONTH(LastSaleDate) ), [Month over month])
Part 1 and Part 2 of this series are excellent. Very clear and well presented. Keep up the great work!
Great Series Reid specially the variable you use for the six month average. Very clever. Look forward for part 3!
Very nice Video Reid!
Please, could you share with us in which site you search for your Unicode characters?
Thanks a lot!
Hi Reid,
Thank you so much for these videos.
Are you using daxstudio ?
Great job! Keep it going.
amazing.....!
Brilliant!
Hi, I have one question about kpi matrix. Can I set alerts on KPI Matrix visual.
What will you get for the KPI if 6 month average is 0?
Hi there, which KPI? There are a few on the page
@@havenscr The one where you used >= for the going up graphic and
@@havenscr I have also got A result of $0 for my six-month trend. is there a common error that makes this occur
Sales Amount 6 month trend =
VAR LastSaleDate = LASTDATE ('Turnover YTD'[Project Invoiced Date])
RETURN
AVERAGEX (
DATESBETWEEN (
'Turnover YTD'[Project Invoiced Date],
DATEADD(STARTOFMONTH(LastSaleDate), -5, MONTH),
ENDOFMONTH(LastSaleDate)
),
[Month over month])
My issue is LAST DATE: I dont know what my data is to match "Sale[Date]"