Sort out preset time periods
Hi, I have an issue trying to set up a slicer for preset time periods like "Last 24 hours", "Last 48 hours" and "Last 1 week". When pressing the diffrent time periods I want all of the data to show for that period. But since I'm using a calculated column that converts the date/time column to "24h", "48h" and "1w", it only show the 48-24 when pressing "48h". How can I make it so all data is included? All help and tips are appreciated 🙂
