Forum Discussion
Combine data across multiple columns
1) You can create one dimension table (it's called a role-playing dimension). You would create one active relationship to the fact table and one inactive relationship. When you write a measure you state which relationship to use.
However, if the dimension table is relatively small, you can use 2 versions of the table (DimDischargeDept and DimAdmitDept) - the DAX will be simpler and you can put either or both slicers in a report. You would use 2 active relationships.
2) Is this to create the Dimension table? If so, you would do this in Power Query, just create a table from the Distinct values from the first 2 columns and then append the distinct values from the other 2 columns
Can you explain how to do this in Power Query? I am very new to Power BI!
I am trying to address a similar issue where I have multiple columns of data per row that I could ideally report on as if they all fell within the same column. Each row is a donor and subsequent columns include the Date and Amount of each of their gifts. I'd like to make a matrix that can show me a sum total of all their gifts by month.
JuliaMcLaughlin it's a very old thread Please post a new question with sample data and desired output.
If you mention me in the new post I may be able to help but someone will help.