Many to many relationship issue

Good morning All,

I am trying to achieve a visual like below.


Predicted Mileage and Lost Mileage come from wo different tables and there is only one common column “Weekday” which could connect them both. There are no exact dates in "Predicted Mileage " table. My bridge table “Weekday” with unique values for Weekday didn’t work for me so I am asking you for your help.

Grateful as usual,


Daily Mileage Usage - forum.pbix (79.5 KB)

See if it helps
Daily Mileage Usage - forum.pbix (94.8 KB)