Results before a selected date

DAX DAX Calculations
1

Hello,
In the following video: https://www.youtube.com/watch?v=MooZofz5GOI&t=567s, at 2:58, Sam recommends creating a second date table as he describes in the video. so it doesn’t filter the bar chart on the top.

There is still a relationship between the original data table, and the new one, So My Question is Why can’t we use the same date table, and instead edit Interactions so this second slicer doesn’t filter the first bar chart, And This Bar chart should then just show result based on the DAXmeasure

Is my logic correct in thinking this way?

2

I guess that’s also the reason why that approach won’t work, because if the bar chart can’t pick up on the selection change of that second slicer it won’t evaluate the measure and show the desired results…

I hope this is helpful.

3

Hello @jps, good to see that you are having progress with your inquiry. :slight_smile:

Did the response from @Melissa help you solve your inquiry?

If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

4

Hi @jps, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.