Forum Discussion

NAOS's avatar
NAOS
Advocate III
8 years ago
Solved

Relations between tables

Hi everyone,   I'm fairly new to Power BI and I'm stuck with modeling my data.   I got three tables,   One with energy production data for different countries and years by Product (Coal, Nucler...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi NAOS,

     

    Based on your explanation the best way would be to do a table with countries and another one with a calendar and make the relatioinship between these two tables and the other 3.

     

    Check this link to create a calendar table on Power BI, however if you google it you will get lot's of different ways to make calendar tables in DAX or M language.

     

    Regards,

    MFelix

     

     

MFelix's avatar
MFelix
Super User
8 years ago

Hi NAOS,

 

Based on your explanation the best way would be to do a table with countries and another one with a calendar and make the relatioinship between these two tables and the other 3.

 

Check this link to create a calendar table on Power BI, however if you google it you will get lot's of different ways to make calendar tables in DAX or M language.

 

Regards,

MFelix

 

 

  • NAOS's avatar
    NAOS
    Advocate III
    8 years ago

    Hi MFelix,

    Thanks a lot for your answer. It worked well.

    Kind regards,

     

    NAOS