Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

YoY Calculation doesn't work with a slicer

Hi,   I have a data table like below where i'd like to select a date in a slicer and calculate Year over Year sales. Slicer has 3 date options. Last Year, Last Month and Year to date and it is bas...
Need Help
mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago

You have to put closing bracket at the end 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

mh2587 when i added that bracket it worked however it removed all filters in the dashboard and returning wrong values.

 

My original TY formula works the challange is when a slicer selected i can't get Last year [LY} formula to work. 

The way i am reading is when i select YTD it pulls sales for YTD 2022 but i cant get YTD 2021 and calculate YoY Chg. This issue is with [LY] formula. Please note Slicer Date column i added later on to the table based on values in Calendar Year.

 

Hope this helps clarify.

 

Thanks