Why 8850 Form Totaling 2016-2023

Instructions and Help about Why 8850 Form Totaling

Welcome to exhale magic trick number 1398 hey if you want to download this excel workbook EXO nice trick 1398 finished or the start file so you could follow along click on the link below the video hey we got a great video here where we're going to talk about dax formulas for running total and % a running total and we'll see a few other cool Dax formula tricks now the last couple videos have been all about running totals we saw how to do running totals and % running totals with pivot tables and then we saw three different videos about formulas but in this video we want to see how to do it with Dax warn us now here's our first data model pivot table using Dax formulas and we need to create the categories with a lower and upper limit 1 2 50 51 to 100 and notice the increment for each one of these is the same each increment between lower and upper is exactly 50 then we need Dax formulas to count so there was a hundred and three transactions that had quantity between 101 and 150 then we need our running total so that's cumulative running total through all three categories 173 that means there were 173 transactions that had quantities of 150 or less and we need our percent running total or percent cumulative total so 42 percent of our transactions had quantity of 150 or less now our second data model pivot table will be based on month and notice for any particular row here we're going to calculate total quantity which is different we're going to be adding the quantity up here we were counting but we're going to add then calculate a cumulative total and percent cumulative but notice...