topic Re: Time Frame in DAX Commands and Tips

Time Frame

onevagi — Wed, 10 Jul 2024 13:27:37 GMT

Hi,

I have column which includes timeframe of 30 minutes for a day (Example: 00:00:00, 00:30:00, 01:00:00, 01:30:00.... till 23:30:00). I have created a Line and clustered column chart, the timeframe is in the X-Axis and I need the timeframe only from 08:00 to 20:00, So basically I need timeslice of the timeframe which I have. Any solution would be of great help. Thanks.

Kind Regards,

Omkar

Re: Time Frame

Alican_C — Wed, 10 Jul 2024 14:24:10 GMT

You can use the following steps:

Create a new calculated column to mark the rows that fall within the desired timeframe.
Filter the visual by the use of new column

1. Creating the calculated column:

IsWithinTimeframe = IF(HOUR([TimeColumn]) >= 8 && HOUR([TimeColumn]) < 20,1,0)

2. Filtering the data:

Go to the "Filters" pane.
Drag the new IsWithinTimeframe column to the "Filters on this visual" area.
Set the filter to only include rows where IsWithinTimeframe is 1.

Re: Time Frame

onevagi — Wed, 10 Jul 2024 16:18:42 GMT

Hi,

Thank you so much for the help. It worked. Cheers 🙂