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.
Hi,
I have two tables and I want to show any changes in table two from table one. For example:
1. The stroke can have more than one row of data
2. Table 2, not all strokes will have made a change of hanger reference
3. Table 2, new stroke references can be seen (though these should be excluded.
How do I get a table that matches the result table?
Solved! Go to Solution.
One approach would be to start with Table 2, merge in Table 1 matching on Stroke, expand the Table 1 reference column, and then filter the resulting table with the rule [New Reference] <> [Previous Reference]. Note: this would give 123125 twice in the final table instead of having a blank cell.
=let a=Table.Buffer(Table.Group(Table1,"Stroke",{"t",each [Hanger Reference]})) in #table({"Stroke","New Reference","Previous Reference"},List.TransformMany(Table.ToRows(Table.Group(Table2,"Stroke",{"t",each [Hanger Reference]})),each let r1=a{[Stroke=_{0}]}?[t]? ??{} in if List.ContainsAll(r1,_{1}) then {} else List.Zip({List.RemoveItems(_{1},r1),List.RemoveItems(r1,_{1})}),(x,y)=>{x{0}}&y))
Thanks Daniel. will I add this as a query?
just copy this code in your new step
Sorry i am not following. Where would I add the code? Will this be a new measure or a new column?
One approach would be to start with Table 2, merge in Table 1 matching on Stroke, expand the Table 1 reference column, and then filter the resulting table with the rule [New Reference] <> [Previous Reference]. Note: this would give 123125 twice in the final table instead of having a blank cell.
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.