Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to get only data for next or previous X hours

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!

  • Anonymous

     

    You can use any of this options:

     

    Filtering Rows

     

    Filtering Rows

    Creating a New Column:

     

    Adding a Column

1 Reply

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion

    Anonymous

     

    You can use any of this options:

     

    Filtering Rows

     

    Filtering Rows

    Creating a New Column:

     

    Adding a Column