topic Re: Multiplying rate with hours in DAX Commands and Tips

Multiplying rate with hours

fjjpeeters1976 — Tue, 05 Dec 2023 14:55:57 GMT

Hi,

I need help with the following. I am probably thinking to complicated.

I have a big database with total costs and hours worked by country. Based on this I calculate the costs per project hour (filtered on year), so outcome for one year is as following

In the same table I have a split for which business unit each country has worked for. So for example Finland worked 70 hours for BU A, 30 for BU B and 80 for BU C

Now I want to multiply the rates per country by the hours to get the following table. However I do not know exactly how to do this. Rates are based on countries and not on business units.

Any suggestions?

BR,

Frank

Re: Multiplying rate with hours

some_bih — Tue, 05 Dec 2023 15:20:23 GMT

Hi fjjpeeters1976 possible solution depend how you organized your table inputs.

How your inputs tables look like? We see two pictures.

Re: Multiplying rate with hours

fjjpeeters1976 — Tue, 05 Dec 2023 15:29:09 GMT

Basically I have 4 tables, one is a table with cost data from an ERP system, one other table is an hour report from a project management tool. I have another time table for all the days, months, years and I have one table which basically is just linking the cost and hour table based on countries (germany, finland, sweden). So with a filter on the year I have calculated the total cost by country dividing by the total projects hours by country. This gives me an hourly rate per country per year. So this hourly rate I would now want to multiply with the hours spend for each business unit.

Re: Multiplying rate with hours

some_bih — Tue, 05 Dec 2023 21:24:37 GMT

Hi fjjpeeters1976 I created little file with some example data. Please check if it is good example for your case and desribe desired output.

Re: Multiplying rate with hours

fjjpeeters1976 — Thu, 04 Jan 2024 07:30:51 GMT

thanks for the help. sorry for my late reply