Forum Discussion
Relationship not working
Happy 2021 and happy lockdowning forum,
File 1, model working fine
My data has a list of deliverables with a planned date and actual date. I upload data twice, i create a relationship between planned dates, actual dates, and a universal calendar. DAX code calculates running amounts and I plot both curves on same graph.
File 2, relationship not working, process is replicated from file 1
a. Relationship between planned dates and calendar is working fine. I can't figure out why relationship between calendar and actual dates (date modified) is not working. Hence Dax is not working on actuals and numbers are not running.
b. Notice how the sum for actuals is bigger than sum for planned. The actuals need to be filtered out of the rows that are planned. Will this be easy to address when relationship at a. works or is there a need for an alternative relationship?
Files at wetransfer link: https://we.tl/t-hwzY6rlYYL
Snip further below
Thanks Forum
Mike_Mace the problem is date modified in the actual table contains time value in it and that's why the relationship is not working, I just added a new column which is date only, and all worked fine. see attached.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
Mike_Mace the problem is date modified in the actual table contains time value in it and that's why the relationship is not working, I just added a new column which is date only, and all worked fine. see attached.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡