Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

PowerBI/Excel DAX Model Help

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

Need Help

4 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks, was able to resolve the issue.

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago
        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.