relation into two tables

YETIANRI EMMANUEL OUSMANE SORI 241 Reputation points
2021-03-12T08:24:46.923+00:00

Hello,
I have two tables that I want to relate in power BI. What's the best possible relationship? Does the data structure of my two tables allow me to make a relation? If not, what should I do? Attached in capture my tables. I want to be able to highlight the expenses against the allocated budget.
Expenses table: Date, Invoice, Amount, Label, Supplier name, Heading, Site
Budget table: Heading in column and sites in horizontal.
Urgent

Best regards

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,760 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Matt Allington 332 Reputation points MVP
    2021-03-14T06:30:57.86+00:00

    What's the best possible relationship?
    One to many.

    Does the data structure of my two tables allow me to make a relation?
    You will always be able to make a relationship. Whether it is a useful one depends on many things.

    If not, what should I do?
    Read and learn. You can start here. I have curated lots of information to get you started. https://exceleratorbi.com.au/knowledge-base/

    Attached in capture my tables. I want to be able to highlight the expenses against the allocated budget.
    Expenses table: Date, Invoice, Amount, Label, Supplier name, Heading, Site
    Budget table: Heading in column and sites in horizontal.

    Yep - there’s a lot to do. Read the articles I posted above.

    Urgent
    Really?

    0 comments No comments