Forum Discussion
Relationships
in short
Delete the relationship between budget and invoicesGet a calendar table and join to budget and invoices
use the customers table and calendar table to slice and dice your visuals
write measures over your budget and invoices table
ChrisDurham , Do not Join, Budget and invoice, Create common tables like date or any other dimension join both tables with that.
https://www.seerinteractive.com/blog/join-many-many-power-bi/
https://www.youtube.com/watch?v=Bkf35Roman8
Try to be in star schema - https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
ChrisDurham , Do not Join, Budget and invoice, Create common tables like date or any other dimension join both tables with that.
https://www.seerinteractive.com/blog/join-many-many-power-bi/
https://www.youtube.com/watch?v=Bkf35Roman8
Try to be in star schema - https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/