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 new to Power BI and need help with DAX calculation. I have following fields (till Paid Amount) in my report and I am trying to calculate Employee FTE field. Value should be calculated based on Assignment FTE (2 distinct Assignments and so it be .25+.75=1 FTE for Employee 1 and .5 for Employee 2). Seems straight forward but I am unable to get it correct. Appreciate any help.
Thanks,
-Raj
Solved! Go to Solution.
I was able to find similar question asked and able to get the calculation working.
Below calc helped me.
I was able to find similar question asked and able to get the calculation working.
Below calc helped me.
I am able to calculate accurate values by creating 2 tables but I have few other columns that I need to do the same. Is there a way that I can just include all this in a new column or measure instead of creating 2 tables?
Here is what I did so far:
Creating AssignmentFTE Table
AssignmentFTETable=summarize(EmployeeTable,EmployeeNumber,AssignmentNumber,AssignmentFTE)
I then created another EmployeeFTE table:
EmployeeFTETable=summarize(AssignmentFTETable,EmployeeNumber,"EmployeeFTE",sum(AssignmentFTE)
EmployeeFTE is correctly calculated but is there a way I can do all this without creating tables i.e just placing all this logic in a new column? Appreciate any help.
Thanks,
-Raj
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 |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |