Forum Discussion

12scml's avatar
12scml
Icon for Resolver I rankResolver I
9 years ago
Solved

Matching Start Dates with Month numbers

Hello! I'm currently working with 6 tables that carry values from various locations based on month number. So all of the tables share the same locations and share months numbered 1-100, but with d...
Need Help
  • 12scml's avatar
    12scml
    9 years ago

    Hi! Thanks for your help but I was actually just able to get it now! I attached a date column with every table and used the "fill" command to make sure that no dates were missing. From there, I was able to establish a relationship between my tables. 

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi 12scml,

 

Could you post all your structures with some sample data and your expected result, so that we can better assistant on this issue? It's better that you can also share a sample pbix file if possible. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards

12scml's avatar
12scml
Icon for Resolver I rankResolver I
9 years ago

Hi! Thanks for your help but I was actually just able to get it now! I attached a date column with every table and used the "fill" command to make sure that no dates were missing. From there, I was able to establish a relationship between my tables. 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi 12scml,

     

    Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread? :smileyhappy:

     

    Regards