Forum Discussion
YTD comparison with data from a fixed year
Dear experts, I cannot get my head around the following requirement for one of my reports that presents the number of orders (we're an escape room operator) over time. Basic function of that rep...
Thank you for your reply, lbendlin !
Your solution works if I set my date slicer to the present year (2022) which is ok for the use case at hand. However, if I wanted to be able to change the "present date" (by adjusting the slicer to e.g. 1st of January 2021), the calculated dates are moved back similarly (in this case I would see 2018 instead of 2019 figures), won't they?
Hi PhilipD,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng