Forum Discussion

ali_a's avatar
ali_a
Frequent Visitor
6 years ago

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