Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX Formula for Showing Change Over Time Based on Filter

Hi!

 

I'm stuck on how to make this happen. I am wanting to create a dashboard where I can compare data pulls from 2 different dates. For example, in the screenshot below, the left side would show data from 11/6 while the right side would show data from 10/25. 

 

I want to also show the $ and % change on the left side, which would be based on the selections from the top left and top right slicers (so I want it to be dynamic). Is there any way to create 2 DAX formulas that would get the $ change and the % change based on the selections of those 2 slicers?

 

Thank you!