Need Help with power BI formula

[Anonymous]

Hi everyone,

I need your help please on a formula to be able to have a report on power BI.

Bellow the problem that i'm facing:

I need to extract a data from a table to calculate the monthly cost and yearly cost of profils per Region.

I have a table with the profils sorted

I have another table witch contains the regions

And a another witch contains the unit cost of a profil

I need to add to my table a column to calculate the cost of each profil and cost of profil by Region.
please see below my screen shot, 

[Anonymous]

Try using the Merge Query option to do a lookup and pull only the relevant columns.

You can then use a calculated column to calculate cost of each profil. Can you share the screenshot of the other table?

[Anonymous]

Hi @Anonymous 

Thanks for your response

Here is the table of the costs

Could you please tell me how works the "merge query"? I just started to use power Bi lately (may be a month ago) so i'm not that good with it.

Regards,

[v-frfei-msft]

Hi @Anonymous ,

Creating relationship between your tables is the key in your scenario. Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous · Accepted solution]

Hi @v-frfei-msft

Sorry for my late response, actually the problem is no longer persisting.

I have just changer the parameters in the matrix and it worked.

Sorry for my late response.

Regards,

[Anonymous]

The profil column is a calculated one, so it doesn't appear in the merge query, i only have the coloumns that i puted as an excel input