Forum Discussion
Actual vs Target Modeling Issue
Hello, I'm trying to build a visual which shows me my Actual vs Target. I need this broken down for all of our store locations. I created the Data Model, but for some reason, the visual shows the...
Hi Tooks9597 ,
The columns that have a relationship should match with each other. You're using Dates[Date] to Target[Month] which doesn't make sense as the latter only has the end of months. Instead, use Mth Yr and make sure the relationship flows in one direction from Dates to Target. This will be likely many to one or many to many
