Question about the Basic Time Intelligence Labs in this course:
Is the measure provided in “Solution” for rolling averages correct? Even in the earlier videos (modules?), the measure, as expected, uses an average function.
By using the Sales measure, it’s calculating a Total, not an average…
[NOte: I renamed the Sales measure to because I was questioning that measure…]
Rolling Avg 30 Days =
CALCULATE(
[Sales OFF],
DATESINPERIOD(
‘Date’[Date],
MAX(‘Date’[Date]),
-30,
DAY)
)
Thanks in advance.
@bgillaspey1 Correct, the calculation is for Running Sales and not Running Avg. Can you share the link of where you are finding all of these exercises?
Mastering DAX Calc’s Time Intelligence Lab
Hoping this helps. Screen shot is below, too. Just in case.
Just curious: Are you on staff at EDNA? or just a frequently responding Expert? (It’s related to my other question: how do I get EDNA’s attention to get these errors fixed…)
And there are other problems with these labs…would you like to hear those too?
Thanks
That’s weird. I can’t see that the link was retained.
so let me try again…
Additional info: it’s in the PBIX file. Go the the Solutions version which is supposed to have the answers…
BG
@bgillaspey1 Use the @ symbol to tab people and they will get a notification, like the one you will get for this reply.
@EnterpriseDNA will be able to help you with any of your queries.
1 Like
The @ symbol: I had seen that but didn’t think to pursue it. Thanks for the hint.
bg
Hi @bgillaspey1, thanks for bringing this to our attention.
We will forward this concern immediately to our content team.
Thanks
Hi @bgillaspey1, has the concern here been addressed? If yes, kindly tag the post as solved.
