Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |