Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Icon for Helper IV rankHelper IV
4 years ago
Solved

Creating Measures without common relationship

Hello!  I have a lot of tables in my report, and they are all connected in some way or another.  But, when I bring in a completion date, it won't show correcly and tells me my relationships are wrong...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, nataliesmiy1357 

    If you want to join the tables, you need to adjust the table structure of table b in Power Query Editor. As mentioned by Ashish_Mathur ,you need unpivot table columns  and add a new column [level] in table a.

    After establishing the relationship between the tables, you can directly drag the fields to the table visual to get the results you want.

     

    Pleasae check my sample file.

     

    Best Regards,
    Community Support Team _ Eason

Gabriel_Walkman's avatar
Gabriel_Walkman
Icon for Continued Contributor rankContinued Contributor
4 years ago

It sounds like a bold statement to say your relationships are correct 🙂

 

How are table a and b connected?

I'd maybe try to transpose table a so that there would only be two columns, level and date.

  • nataliesmiy1357's avatar
    nataliesmiy1357
    Icon for Helper IV rankHelper IV
    4 years ago

    The database connections was given to me prior by higher ups - I'm not allowed to change it.

     

    How would I create a transpose table with those columns?