Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
My dataset is an Excel file that is generated by a very inflexible program. In order to make functional tables, I need to unpivot the columns. My problem is that the number of columns in the Excel file changes every time the file is generated.
My data looks like this:
Date | Property | Product 1 | Product 2 | Product 3 .......
When I unpivot the Product columns the formula is:
= Table.Unpivot(#"Changed Type", {"Product 1", "Product 2", "Product 3", .... }
How can I change the function to unpivot all columns from column #3 up to (and including) the last column?
Thanks!
Solved! Go to Solution.
@radomzal you can select the first two columns Date and Property, then Unpivot Other Columns.
It doesn't matter if there is 1 or 100 other columns, they will all get unpivoted.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@radomzal you can select the first two columns Date and Property, then Unpivot Other Columns.
It doesn't matter if there is 1 or 100 other columns, they will all get unpivoted.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI can't believe I missed noticing that was an option! Thanks!
Glad to help @radomzal - I'd say 95% of the time I use the Unpivot Other Columns feature vs the Unpivot Columns feature. 😁
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |