Forum Discussion

icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Calculate History MoM, YoY & Target based off dynamic dates but dataset already filtered

Good day,

 

I have a dataset that contains startofmonth as date for fact revenue & target

Linked to a calendardimension on start of date but returns full date for a dateslicer, many-to-one

so i have revenuew calc based off the slicer/picker from and to dates with custom dates calculating history mon and history yoy

example: 

Slicer selectes Mar24-April24 then Revenue returns 2 months data

but Mom = Jan24-Feb24 and YoY=Mar23-Apr23

so i have calcsmeas that stores the dynamic history ranges and have the calc filter on the ranges

but because my selected range is Mar24-Apr24 the History calcs return nothing as the datset is already filtered and dont find Jan24-Feb24 and Mar23-Apr

i tried to calc using sum with filter(all or filter(allselected or just filter( , but it think my dataset is already filtered by its relationship

and my calc has filters using the custom calc dates

 

im thinking of duplicating my datasets for YoY,MoM, and actual but if they all to the one calendar as i have grapgh to show the trend but once the slicer selects the date my datset is already filtered, even though i switch off interations and the dynamic dates calc are correct ranges i still get nothing

 

please any help?

 

regards 

 

1 Reply