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.
I have a function has three parameters as you can see below in the code of oracle query. I want to pass the date as a parameter but not working as this one  '"&DueDate&"' if I add date without parameter will be work as this one
'31122018' SELECT SUM (db.acc_data.get_mat(c.brnch_No, c.ContractNo, db.dat (db.dtpkg.g2h (TO_DATE ('"&DueDate&"','ddmmyyyy'))))) as sum FROM db.brnchtable c WHERE (acc.get_brnchtype (c.brnch_No) = 1)
now I want to use the date as a parameter. I need your help 🙂
more info about '"&DueDate&"' not show data 🙂
Solved! Go to Solution.
I solved the problem by using the Advanced Editor
I solved the problem by using the Advanced Editor
How did u solve this problem I am facing the same issue please help.
Hi @ali_a
DueDate is a parameter created in Power BI or in Oracle?
What is its type?
This code is correct or not?
'31122018' SELECT SUM (db.acc_data.get_mat(c.brnch_No, c.ContractNo, db.dat (db.dtpkg.g2h (TO_DATE ('"&DueDate&"','ddmmyyyy'))))) as sum FROM db.brnchtable c WHERE (acc.get_brnchtype (c.brnch_No) = 1)
If it is not correct, how about use this code
TO_DATE ("&DueDate&",'ddmmyyyy')
Best Regards
Maggie
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.