Forum Discussion
Unpivoting
Hi, I have data something like this and I would like to unpivot data as indicated below. Appreciate if anyone can help on this as when I tried to unpivot(unpivot only selected columns) the result...
I have found a way to get to your result, but surely there is a better option... Usually, unpivoting works well and is very simple, but like you mentioned, I am having issues getting your desired result through an unpivot alone. Maybe someone else can provide a cleaner solution, but until then:
- Select all Name columns (Measure 1 Name, Measure 2 Name, etc.) and select Unpivot Columns
- Then select all Value columns (Measure 1 Value, Measure 2 Value, etc.) and select Unpivot Columns
- You will end up with a result that looks like this:
- Now, create a custom column that checks to see if Attribute = Attribute.1... For this example, I removed "Name" from Attribute and "Value" from Attribute.1, and then created a custom column with the following statement:
- if [Attribute] = [Attribute.1] then "Keep" else "Delete"
- I then just filtered to only show rows where that custom column = "Keep" and then deleted the Attribute and Attribute.1 columns.
- Final result:
Hi Ashish,
I am having same scenario, but still not able to resovle it.
Could you please share the solution in a PBIX format along with sample data file.
Thanks
Shishir
Hi,
Download the Excel file from the link in my previous post. Open PBI desktop and go to File > Import > Excel.
I will try it, but, Is it possible for you to send the file, as due to restrictions at work, unable to access the Drive location.
Thanks
Shishir