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
In your case you need to use a What If Parameter, which is located under the Modeling ribbon:
Cheers,
Fernando
Thank you Fernando,
That worked but I can't get it to work in a formula, it just keeps using the alternateresult of 0.50, even though the slider says a different value:
WTF = 'QGenda Compliance'[Worked Hours]-'Lunch Deduction Amount'[Lunch Deduction Amount Value]