Creating 5-4-4 Calendar with Power Query This post is a continuation of the my previous post about how to create a 5-4-4. Please read here on how to use this function: Creating a 4-4-5 Calendar with
Tag Archives: M
Creating 4-5-4 Calendar with Power Query This post is a continuation of the my previous post about how to create a 4-4-5. Please read here on how to use this function: https://xcelanz.com/creating-a-4-4-5-calendar-with-power-query/ The M code
Power Query – Add blank row at each change in value This is a follow-up post to a question asked on Mr Excel forum. The OP wanted to use Power Query to add an empty
Histogram with Power Query With the help of custom M coding, it is possible to create a frequency distribution by using power query. This is one area where Power Pivot would shine against Power Query
Creating a 4-4-5 Calendar with Power Query 4-4-5 calendar is a common calendar structure for some industries such as retail and manufacturing. You will need to create such a calendar if you wish to harness
Replicate SUMPRODUCT in Power Query Today I stumbled upon the M function List.Zip which I thought would provide a valid alternative to my previous post about replicating SUMPRODUCT in Power Query. According to Microsoft Power