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
Tag Archives: DAX
Computing New Customers 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
Creating running totals using the List.Accumulate FunctionThe Ken Puls (Excelguru) Blog
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
Filter Arguments in CALCULATE – SQLBI
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
RANKX-apalooza: Within and Across Groups, With Filters, Etc. – PowerPivotPro
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
10 DAX Calculations for your Tabular or Power Pivot Model (Part 1) | SQL with Dustin Ryan
Time Patterns – DAX Patterns
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!
Apply AND Logic to Multiple Selection in DAX Slicer
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)
RSS
SL Galaxy
Facebook
Google+
LinkedIn
Twitter
