Forum Discussion
Help with parameter
Hello, I have a report calculating how many hours an employee works. It has a formula that like: SUM(Regular Hours) + SUM(Extra Hours) - Lunch Deduction. I need to find out from the user what ...
Anonymous
With this code:
WTF = SUMX(WTF, [Working Hours Total] - 'Lunch Hours'[Lunch Hours Value])See here:
Half hour lunchOne hour lunch
Works for me. Maybe you could share sample data and your pbix file.
F
Thank you Fernando, I must have not created the parameter properly because it is not in my field pane. From the Power Query Editor Window, I clicked Manage Parameters, then New, and created Lunch Deduction Amount, then hit Close and Apply. Is there something I am supposed to do after this?
You created the parameter in Power Query... It must be created in the app AFTER you've loaded data from PQ to the model. These two parameters serve different purposes.