The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
Can anyone correct the last line of my DAX formula?
var Work_Days =
CALCULATE(
DISTINCTCOUNT('July 2021'[Date]),
FILTER(
'July 2021',
'July 2021'[Time code] <> "PH"
&& WEEKDAY('July 2021'[Date],2) < 6
))
VAR WFW = SUMX(FILTER('July 2021','July 2021'[Project Name]="WFW"), 'July 2021'[Hours])
VAR emp_count = DISTINCTCOUNT('July 2021'[Employee Name])
RETURN
(((emp_count * Work_Days * 8.5) - WFW)/ emp_count * Work_Days * 8.5)
Solved! Go to Solution.
@TinyElephant , what is the issue you are facing
try like
RETURN
divide(((emp_count * Work_Days * 8.5) - WFW), emp_count * Work_Days * 8.5)
@TinyElephant , what is the issue you are facing
try like
RETURN
divide(((emp_count * Work_Days * 8.5) - WFW), emp_count * Work_Days * 8.5)
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
63 | |
47 | |
41 |