Forum Discussion
ali_a
6 years agoFrequent Visitor
How do I solve pass parameters by users
Hi there,
I have been trying many of way to let users enter value in the parameter by using power bi server report for my organization.
Please, I need to solve this problme by any way. An addition, it's only work by this way -> Home -> Edite Queries -> Edit parameters.
select sum (db.fun_gt.g_m_c ( a.branchoff,
a.cntno ,
db.fun_date (db.dte_pkg.g2h (TO_DATE ('31122018','ddmmyyyy'))))) as sum
from db.Test a;
/*With parameter*/
select sum (db.fun_gt.g_m_c ( a.branchoff, a.cntno , db.fun_date
(db.dte_pkg.g2h (TO_DATE ('"&Pass_Date&"','ddmmyyyy'))))) as sum
from db.Test a;Thanks :)
No RepliesBe the first to reply