Forum Discussion
Solved
SelectedValue function not working correctly within a calculate(sum) ?
Check this out. I have sales data going back to 2018 in this dataset. The "YearMinus" shows that the Date(selectedvalue('Query1'[year])-1,1,1) produces 1/1/2021 when clicked on 2022 year....
Zarlot531 Not sure you need a separate table, you could use ALL or ALLEXCEPT to override the slicer filter context and then filter down to the dates you want.
Zarlot531 Not sure you need a separate table, you could use ALL or ALLEXCEPT to override the slicer filter context and then filter down to the dates you want.