Forum Discussion
Date Table Relating to Two Tables with Dates
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.
Hi
Please take a look a this solution:
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
Solution SageHi 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.
Hi mangaus1111 ,
Thank you very much for your suggestion. I changed the relation as per your suggestion and it does work indeed like this. I might have to check if the changed filtering directions had some influence for other graphs in the big report, but so far it looks good! Can't believe I did not try this on my own..
