Tag: Excel Power Pivot

Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables

Welcome to Excel Magic Trick number 1,407. Hey, if you want to download this Excel workbook Excel Magic Trick 1,407 finished file or the start file so you can follow along, click on the link below the video. Hey, back in Excel Magic Trick 1,405, we saw how to create a monthly revenue and add…

Read MoreView 11 Comments

Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)

Welcome to Excel magic trick number 1,408. Hey, if you want to download this Excel workbook, Excel magic 1,408 start file or the finished file, so you can follow along, click on the link below the video. Hey, back at Excel magic trick 1,406, we were trying to calculate a moving 12 month average. Here’s…

Read MoreView 20 Comments

Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?

Welcome to Excel Magic Trick number 1,378. Hey, if you want to download this Excel workbook– Excel Magic Trick 1,378 Start– or the finished file so you can follow along, click on the link below the video. Hey, we’ve got a great video here. We’ve got to calculate the average of customer total sales by…

Read MoreComment

Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables

Welcome to Excel Magic Trick number 1,407. Hey, if you want to download this Excel workbook Excel Magic Trick 1,407 finished file or the start file so you can follow along, click on the link below the video. Hey, back in Excel Magic Trick 1,405, we saw how to create a monthly revenue and add…

Read MoreComment