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 originally wanted to know how to create a calculated column to accomplish this. I was given the following code and it worked in desktop mode but not in the query editor.
Running = SUMX(
FILTER(VerbalComplaints,
VerbalComplaints[Day]<=EARLIER(VerbalComplaints[Day])
),
VerbalComplaints[June]).
As far as I can tell the query editor does not recognize DAX functions like SUMX and EARLIER.
My end goal is for this to automatically update a Trend graph. That looks similar to this:
Currently my table (query) looks like this in the Query Editor and I need to replace the contents in the cells with cumulative totals for any column not named Day. I have no idea where to start. If I can complete this last step then the query will produce the data ready to go for the trend graph. I believe I need to have the data fully ready in the query editor to be able to automate. Below is a graphic of my table.
I don't think I can just create a new column and replace.... I literally need to replace the cells populated with daily counts with the cumulative totals. This way my query always pulls in the proper months and names the columns correctly thanks to the pivot I use to create data currently in this table (query).
You are correct, Query Editor uses Power Query "M" Language which is entirely different that the DAX language used in "Desktop".
https://msdn.microsoft.com/en-us/library/mt211003.aspx
And, as it turns out, not NEARLY as easy to do in M as in DAX:
http://www.excelguru.ca/blog/2015/03/31/create-running-totals-in-power-query/
Thanks for clearing that up. Im going to give this a shot. I've never used the M language before.
I read the article but I still have no idea how to write this in M language in the query editor... im so new to this and I haven't used power pivot either. Im still very confused.
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 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |