Forum Discussion
Help with parameter
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
Hi Anonymous ,
When you create a parameter you'll find it in the Fields pane at the right with a table of one column with a series of values depending on your choice when you created it, and a measure:
You just have to use that measure in your calculations.
Regards,
Fernando
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?
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]
- 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.
