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 All,
So I'm fairly new to Power BI, and I'm wondering why (for curiousity's sake more than anything) when using the Advanced Editor function in the Edit Queries screen, that the M code for a step always references the previous step.
e.g. #"Removed Columns3" = Table.RemoveColumns(#"Changed Type2",{"ExitResponse"}),
Where #"Changed Type2" is was the previous step.
This caused me a couple of trip ups when writing steps by hand, so some understanding of why it's doing it would be great to help me write better code.
Thanks!
Adam
because m is a procedural langauge, therefore it creates everything in steps. The last step is all the changes in the data to that point.
Proud to be a Super User!
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |