2 Tables & Relationships

Hi BarryWhitelaw26,

are you using a Calendar table?

It seems that the month comes from one table of the two you created (current year and lat year)

Also, I am a bit worried about this many to many thing

I would need to take a look at the pbix, can you share it via some cloud service and paste the link here or can you

please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question.

Thanks

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Need help uploading data? click here

Want faster answers? click here

Problem: You're seeing repeated totals for Last Year £ because the relationship between your two tables isn't filtering correctly by month.
Fix: Create a Month dimension table and link both This Year and Last Year tables to it using one-to-many relationships. Use that dimension in your visuals to ensure proper filtering.