Intellipaat Back

Explore Courses Blog Tutorials Interview Questions

DAX Utilization % - Measure Formula

0 votes
2 views
in BI by (11.1k points)
How can I perform calculation %Utilization DAX and I am finding hard to figure out the formula

How can I perform this?

1 Answer

0 votes
by (22.5k points)

Use the following measures

[hours available]:=SUMX(DISTINCT(timesheet[resource_key]),CALCULATE(SUM(calendar[utility_hours]),FILTER('calendar',calendar[date_key]>=FIRSTDATE(resources[hire_date_key])),FILTER('calendar',calendar[date_key]<=LASTDATE(resources[termination_date_key]))))

[hours available]:=SUMX(resources,CALCULATE(SUM(calendar[utility_hours]),FILTER('calendar',calendar[date_key]>=FIRSTDATE(resources[hire_date_key])),FILTER('calendar',calendar[date_key]

<=LASTDATE(resources[termination_date_key])))) 

[hours charged]:=SUM(timesheet[bill_hours])+0 

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification     

Related questions

0 votes
1 answer
Power BI first IF-Statement then the DAX-Formula
asked Nov 21, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
DAX VAR defining named variables in the middle of the measure code
asked Mar 4, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Power BI (DAX): Calculating MoM Variance of a Measure Field
asked Feb 22, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
DAX: How to correctly create a measure group from a range of dates?
asked Dec 19, 2020 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2024 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...