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.
I am trying to get total available hours by week which is usually 40 but one person works 20.
In trying to get this in the table by person by week
Is there a conditional statement I can use?
if name is John then 5*4, else 5*8
I've tried a few thing (like this below) and when I add to table with dates by week and names of everyone, I get 87160 instead of 20 for john and 40 for everyone else. Any ideas?
Solved! Go to Solution.
Hi,
Use following DAX formula.
Thank you.
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |