Forum Discussion
Helper IVCreating 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 (when they are not). I was wondering if I could create a new column in the data table to pull in another table's column
table a: [ level1date, level2date, level3date, level4date]
table b: [level]
So I want to create a new column in table b, and if table b[level] = 1, I want to bring in the date from table a[level1date]
Let me know if this is possible! Thanks in advance.
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
10 Replies
- Ashish_Mathur
Super User
Hi,
TableA should be "Unpivoted" to transform it into a 2 column dataset - Level and Date. Thereafter, one can bring over the Date in TableB in either the Query Editor (via Merging) or DAX (via a calculated column formula).
Hope this helps.
nataliesmiy1357I'm not exactly sure what you mean by this... how do I do that? And how do I create a dax formula to bring them together?
- Ashish_Mathur
Hi,
Share TableA and TableB in a format that can be pasted in an MS Excel file.
Gabriel_WalkmanContinued Contributor
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
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?
