I am trying to create a dashboard where the user can select a date, and the single-value tiles would then show the MTD and YTD data up to that selected date.
Along with this, I would like to show some sort of Period-Over-Period comparison (MoM and YoY) based on that same selected date.
Does anyone know how I can go about this?