Unable to get accurate data using Many-to Many relationship

[Dinkar]

I have two tables. 1st table has runs of the jobs executed on each dedicated sql pool  and 2nd table consists of cost for each dedicated sql pool cost and additional resources like cognitive services,firewall etc for particular month. both tables has duplicates. Related using Many- to -Many relationship.  not getting accurate data.

No luck.

Could anyone help on the this and provide referance articles, really helps. Thanks

@

[Idrissshatila]

Hello @Dinkar ,

convert your model into a star schema and link the dimension tables to both tables you have then view the result by the dimensions.

refer to this documentation for star schema model https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin