Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
You can use any of this options:
Filtering Rows
Creating a New Column:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |