Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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