Powerquery - MTD

[Anonymous]

Trying to create custom column in Power Query for MTD

Column = Material, Date and Order Qty

I need MTD Order Qty against each transaction based on Material and Date

[edhans · Accepted solution]

You are getting into date intelligence, and typically that is analysis and best done in DAX. Power Query for shaping, DAX for analysis. However, @ImkeF has done some solid work on cumulative/running totals in Power Query here, so you could look at that if this MUST be done in PQ. Unless you are dropping this to an Excel table vs the Power Pivot DAX model or the Power BI DAX model though, it really would be best done in DAX using the various date intelligence functions available in Power BI in measures.