Forum Discussion

emperkins's avatar
emperkins
New Member
2 years ago
Solved

Relationship & Data Issue

I'm new to working with Power BI relationships.    I have four separate tabs in a spreadsheet, all of which have a date column formatted by Month/Year.    I created three separate relationships: ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi emperkins ,

    Based on my testing, try to copy four tables into the power bi desktop.

    Drag the column into the matrix visual to see if the problem still exists.

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Super User
2 years ago

Does your data model have a designated Calendar/Dates table?

  • emperkins's avatar
    emperkins
    New Member
    2 years ago

    It doesn't. It won't allow me to designate a date table. It keeps saying there are gaps in values, even though there are no null values and it's continguous months/years from 2016 through 2024. 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Create your own then, for example via CALENDAR() . Or better yet, use an externally prepared reference table, as that data is immutable and there isn't really a need to compute that Dates table over and over again.

      • emperkins's avatar
        emperkins
        New Member
        2 years ago

        I was able to create the data table, but I'm still running into this issue only for the month of October.