Dax Measure Advice

[bfaws]

Hi all,

I`m quite new to data modelling and the microsoft power suite but i`m trying to build a Human Resource Dashboard. The basic idea is that I extract a number of reports from our HR system on a monthly basis and then store the files in a number of folder which i`m connecting to so that my dashboard updates monthly.

The specific issue i have is that i can extract absences in the month basicall show as one row per day of absence, and absence type, as well as, the amount of hours absent - this seem a pretty good way to extract the data. I would like a measure that show how many hours are lost to each absence type as a % based on the total available hours (employees contracted hours) per month. I`m a little stuck on how to do this though.

I was thinking that perhaps if I created a seperate lookup table that i could update each month that showed the available hours and then create a relationship between the list of absences and the available hours lookup.

Does anyone think this would work? And if so does anyone have any suggestions for the type of measure that would work?

Thanks in advance for any help.

Brendan

 

[ranman256]

you should use Microsoft Access. Better for wrangling data.