Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a live oracle DB connected to Power Bi refreching every hour always showing the stats of today:
Query goes something like that
"where date >= sysdate"
Now I want to be able to show specefic dates in the past.
How I do it right now:
* Remove the where clause and select all dates in the query
* Show a slicer with every date there is and let the user choose it and dsiplay it
(This methid is very slow and takes a lot of time to load with "select *")
Is there a methid where user enters for example "2021-12-28", and then it'd automatically query:
"where date == '2021-12-28'"
And load this specefic date?
Thank you.
@mahmoud_kfawzy this might help: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |