This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date
Πηγή: Analyzing events with a duration in DAX – SQLBI
In this article, Alberto Ferrari describes a new efficient way to compute returning customers in DAX thanks to an idea suggested by a student attending an O
Πηγή: Computing New Customers in DAX – SQLBI
This article shows how to use the List.Accumulate function in order to create running totals with Power Query.
Πηγή: Creating running totals using the List.Accumulate FunctionThe Ken Puls (Excelguru) Blog
A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This arti
Πηγή: Filter Arguments in CALCULATE – SQLBI
Post by Rob Collie One from the Reference Stacks I sometimes find RANKX() a bit perplexing. So awhile back I made myself a workbook of examples, which I will share with you today: List of Stores, Grouped by Region, and…
Πηγή: RANKX-apalooza: Within and Across Groups, With Filters, Etc. – PowerPivotPro
DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of PowerPivot. Create your Excel data model faster by using a DAX pattern!
Πηγή: Time Patterns – DAX Patterns
Apply AND Logic to Multiple Selection in DAX Slicer – SQLBI http://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/ (Κοινή χρήση από CM Browser)