Forum Discussion
CathleenO
3 years agoFrequent Visitor
Time Intelligence
Hello, I need some help with a complicated time intelligence calculation. Its been working perfectly within my graph, but as we push forward into 2024, as its "datesytd" this calculation no l...
CathleenO
3 years agoFrequent Visitor
Thanks Amitchandak,
So, as we are 2023, and the formula is fully functional for 2023, but I need to add 2024, would it work as follows? I will try it. LMK what you think.
CALCULATE([Rolling Inventory Calc],DATESYTD(dateadd('Calendar'[Date], +1, Year)))