How to get only data for next or previous X hours

[shds]

Hello,

I just found out that it is not very easy to do a SQL-like query on DateTime fields where the value should be BETWEEN datetime 1 and datetime 2.

How is it possible to achieve this for a dataset in PowerBI? I would like to get a set of records that only shows the next 36 hours for example. I have experimented with a custom column ("IsNext36Hours"), but cannot figure out how to fill it properly.

Any suggestions on how to achieve this?

Thanks in advance!

[Vvelarde · Accepted solution]

@shds

You can use any of this options:

Filtering Rows

Filtering Rows

Creating a New Column:

Adding a Column