Anyone know if it’s possible to Period Over Period functions with a date control? My leadership team would like to see YOY data shown as YTD, but also wants the ability to change the dates so they can view Mar - May for example.
Every Period Over Period function I’ve tried to use does not allow me to filter different dates. I can properly calculate YOY, but as soon as I select a date then the YOY disappears or shows ‘No Data’.
In Power BI, the way I got around this was to use an ‘ALL()’ function, which essentially allows you to ignore all selected filters while performing the calculation. I have been trying to find something similar in Quicksight but haven’t had any luck.
Any assistance would be greatly appreciated.