Tag: Data Model

Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop

Welcome to Excel magic trick number 1,443. Hey, if you want to download this Excel workbook, either the start file or finished file so you could follow along, click on the link below the video. Hey, we’ve got to see how to create a DAX formula for calculating sales per working day. And of course,…

Read MoreView 22 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