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 could use GroupBy but I only want to Combine data with column that has particular value? I want to only combine rows with value B. Off course there are other columns as well.
Value A
Value A
Value B
Value B
Value B
Value B
Value C
Value C
Value C
Solved! Go to Solution.
Could you:
Make 2 reference copies of the initial query.
Filter 1 to just include B rows and the other to not include B rows.
Apply group by to the query with just B rows.
Append the queries back together.
Mark all the helper stages as do not load.
Here's one way to do it in the query editor. To see how it works, just create a blank query, open the Advanced Editor and replace the text there with the M code below.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkvMKU1VcFSK1YlWAhM4BJyoIOBMjEAsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Value = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Value", type text}}),
Split = Table.SelectRows(#"Changed Type", each ([Value] <> "")),
#"Filtered Rows" = Table.SelectRows(Split, each ([Value] = "Value B")),
#"Grouped Rows" = Table.Group(#"Filtered Rows", {"Value"}, {{"Count", each Table.RowCount(_), Int64.Type}}),
Custom1 = Split,
#"Filtered Rows1" = Table.SelectRows(Custom1, each ([Value] <> "Value B")),
#"Appended Query" = Table.Combine({#"Filtered Rows1", #"Grouped Rows"})
in
#"Appended Query"
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Could you:
Make 2 reference copies of the initial query.
Filter 1 to just include B rows and the other to not include B rows.
Apply group by to the query with just B rows.
Append the queries back together.
Mark all the helper stages as do not load.
Great clever IDEA!! 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.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |