Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
92 | |
86 | |
76 | |
64 |
User | Count |
---|---|
137 | |
113 | |
107 | |
98 | |
92 |