Forum Discussion
Anonymous
9 years agoNot applicable
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
Community Champion
Anonymous
You can use any of this options:
Filtering Rows
Filtering Rows
Creating a New Column:
Adding a Column