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.
Hi,
I was hoping someone could help. I`m pretty new to DAX and I`m struggling with a measure. I`m trying to figure out two figures based a a list of employees and report dates. I need to essentially know how many actual employees we have in a single month as well as what the full time equivalent (FTE) is for that month. I have managed to figure out the actual count of employees but it is the full time equivalent that I`m struggling with.
This here is what the table looks like:
and this is the expected result:
Any help would be much appreciated.
Thanks.
Solved! Go to Solution.
Seem like you want to do a count and a sum?
Nothing special needed in that case. Just set the calculation to sum in the values part of the table.
See;
Power BI file available here.
Please mark as solution if this is what you are looking for.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Hi @Bfaws
Would this not be sufficient?
Measure = SUM(Table1[FTE])
where Table1 is the first table you show
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Seem like you want to do a count and a sum?
Nothing special needed in that case. Just set the calculation to sum in the values part of the table.
See;
Power BI file available here.
Please mark as solution if this is what you are looking for.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |