PowerBI/Excel DAX Model Help

[Anonymous]

Hi,

I have a newspaper print sales table which joins to a calender table via the date and to the title table via the title code.

I also have a insert table which holds the infromtion when an ad has ran and again there is mutliple values in it which joins to the calender table and to the title table.  However when I put the adnumber in my matrix table and try to bring in the cost from the insert table and the number of papers sold from the newspaper table they do not match, even though I have a column as a date from the date table.

Any idea how I would go about joining these up?

Thanks

Chris

[Eric_Zhang]

@Anonymous

For a better understanding on your case, could you share a pbix with data model and sample data? You can upload a pbix to Onedrive or any network drive and share the download link.

[Anonymous]

Thanks, was able to resolve the issue.

[Eric_Zhang]

---

@Anonymous wrote:

Thanks, was able to resolve the issue.

---

@Anonymous

Great to hear that.

It would be perfect if you could share your scenario and solution. People who have the similar case would benefit from the solution.

[Anonymous]

Hi v-lvzhan-msft,

I used a join in SQL, couldnt get it to work in PowerBI.

Thanks

Chris