Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the lunch deduction is, so I"ve created a parameter with values .50, 1.0, 1.5, etc. But now I don't know how to use this parameter on the report. How do I display it, and how do I grab the value and add to my formula?
Thanks.
Solved! Go to Solution.
@Anonymous
With this code:
WTF =
SUMX(WTF, [Working Hours Total] - 'Lunch Hours'[Lunch Hours Value])
See here:
Works for me. Maybe you could share sample data and your pbix file.
F
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |