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.
I would like to consolidate the number of Business Value KPI_Metric rows below from 9 to 3 by having the values within the Metric, Target, and Calculation / Approach columns in the same row. For example; row 1 would have Reduce in-center processing, Test LI1, Test LI1 - 10, and Test LI 1. Does anyone know if this can be done in the query editor?
Thanks in advance to anyone who can assist.
Solved! Go to Solution.
You can do it within the Table.Group function.
Then just expand the resulting table
#"Grouped Rows" = Table.Group(#"Replaced Value", {"Business Value KPI_Metric"}, {
{"Collapsed", each
Table.SelectRows(
Table.FromColumns(
{[Business Value KPI_Metric],List.RemoveNulls([Metric]),List.RemoveNulls([Target]),List.RemoveNulls([#"Calculation/Approach"])},
type table [Business Value KPI_Metric=nullable text,
Metric=nullable text,
Target=nullable number,
#"Calculation/Approach"=nullable text]),
each [Metric]<> null)}}),
Replace #"Previous Step" with the actual name of the previous step in your code.
You can do it within the Table.Group function.
Then just expand the resulting table
#"Grouped Rows" = Table.Group(#"Replaced Value", {"Business Value KPI_Metric"}, {
{"Collapsed", each
Table.SelectRows(
Table.FromColumns(
{[Business Value KPI_Metric],List.RemoveNulls([Metric]),List.RemoveNulls([Target]),List.RemoveNulls([#"Calculation/Approach"])},
type table [Business Value KPI_Metric=nullable text,
Metric=nullable text,
Target=nullable number,
#"Calculation/Approach"=nullable text]),
each [Metric]<> null)}}),
Replace #"Previous Step" with the actual name of the previous step in your code.
Brilliant. Thank you!
Covering 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.