BrianJ
September 23, 2020, 1:33pm
2
@Amdi ,
Thanks very much for the input - really glad to hear that you’re finding the videos helpful.
I’ve attached the PBIX file below, and am looping in @EnterpriseDNA , so that they can add the PBIX to the course entry permanently.
Video 3 - IsAfterToday.pbix (3.1 MB)
The Carryover scenario I used in this video is a simplified version of a fascinating question that got asked on the forum early this year. Here’s the relevant thread if you’re interested:
@adsa and I have been working on this one for a couple of days now and have gotten stuck right at the goal line, and could really use a fresh pair of eyes taking a look.
You can read the background on this thread here . It’s an interesting problem – basically calculating a cumulative total of a net measure prior to an ALLSELECTED date range (call that prior cumulative total “carryover”), then calculating the cumulative total of the measure over the ALLSELECTED date range (call that cumulative t…
I hope this is helpful. Please give a shout if you have any other questions.