Tag: DAX Measure

Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total

Read MoreView 8 Comments

Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks

Welcome to Excel Magic Trick number 1,398. Hey, if you want to download this Excel workbook Excel Magic Trick 1,398 finished, or the Start files, so you can follow along, click on the link below the video. Hey, we’ve got a great video here. What we’re going to talk about DAX formulas for running total…

Read MoreView 30 Comments

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 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 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years

Welcome to Excel Magic Trick number 1,449. Hey, if you want to download this Excel file so you can follow along, click on the link below the video. Hey, we got to see how to create a DAX measure for percentage change, both for month over month and year over year when we have incomplete…

Read MoreView 33 Comments