Sort out preset time periods

[NikolaiM]

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 🙂

[ValtteriN · Accepted solution]

Hi,

I am not sure I follow, but anyway I recommend creating this kind of time intelligence options using calculation groups. So either user Tabular editor or do the following:

1. Go to Modelling view and select calculation groups:

2. Press the ... and create a new calculation group:

e.g. 24h: 

24h = CALCULATE(SELECTEDMEASURE(),ALL('Calendar'),'Calendar'[Date]>= NOW()-1)

Example data and usage:

Measure 31 = SUM('Table (42)'[Data])

When applying the calculation group only the row which is within 24h is shown.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/