Forum Discussion

aekoll's avatar
aekoll
Frequent Visitor
3 years ago
Solved

Date Table Relating to Two Tables with Dates

Hi everyone,   First of all thank you very much for trying to help me. I am relatively new to Power BI and still learning. I am currently facing an issue where I can not wrap my head around.   I ...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi aekoll ,

    try first to set a relationship 1 to many between data table and weekly totals and then change all the relationships from bi-directional to single directional like in this example:

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • onurbmiguel_'s avatar
    onurbmiguel_
    3 years ago

    Hi 

    Please take a look a this solution: 

    LINK

     

    If this is not what you pretend, please send a draft what should by the final result.

     

    Best regards

    Bruno Costa | Continued Contributor

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal 

     

onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
3 years ago

Hi 

Please take a look a this solution: 

LINK

 

If this is not what you pretend, please send a draft what should by the final result.

 

Best regards

Bruno Costa | Continued Contributor

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal