Running Total or Cumulative Total column in Power Query
Please please PLEASE make it possible to create a running/cumulative total column in Power Query. The amount of hoops I have to go through to get something as simple as a cumulative value column is crazy. Power BI is able to do things that are ALOT more complex than a running/cumulative total column so I'm confused as to why it has to be so difficult. Even after searching for solutions for HOURS, I have not found a solution for a running/cumulative total column in Power Query without having to copy and/or group a table.
Power Query Aligning rows in a table to first non 0 value in each row
Hello, I am working with some project and financial data and wanting to align each row to 1st month that spend occurred. Basically wanting to align the data so it is collapsed to when the spend started for each project so I can run and average monthly spend rate. I looked around in the archives and have not been able to find anything decribing how to go about this, appreciate any insight. thanks!
No Query Folding in Dynamics 365 CRM (formerly CRM Online)
I cannot get any query folding when using Dynamics 365 CRM data. I read a blog about this at http://community.powerbi.com/t5/user/VerifyUserEmailPage/user-id/3931/mail-message-tracking/IVMQMLZNCXMFYS?$destUrl BUT, I have been unsuccessful with the solution suggested in this blog. COULD BE PEBCAK pretty easily! I also have been unable to connect to content packs with D365 CRM.
