Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
mahmoud_kfawzy
Frequent Visitor

How to take date as a user input and run the query according to it?

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.

1 REPLY 1
AllisonKennedy
Super User
Super User

@mahmoud_kfawzy  this might help: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters 


Please @mention me in your reply if you want a response.

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.