Artikel mit dem Tag "DAX"

Power Query · 18. Januar 2021
Events and projections, using M
I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.
DAX · 17. Januar 2021
Events and projections
There is just one thing that is more satisfying than writing complex DAX measures, and that is avoiding complex DAX due to smart data modeling.
DAX · 02. November 2020
This article will provide a different approach to tackle a common requirement, determining the previous value given a current date.
Power BI · 13. Juni 2020
A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division
DAX · 04. März 2020
This blog provides an introdution into some universal truths, of course things like evaluation context, or data lineage will be mentioned
Power BI · 30. April 2018
This article is the starting point of a series of articles that demonstrates how to navigate through tables inside a Tabular Model, from Microsoft Analysis Services Tabular, Power Pivot or Power BI using DAX
Data Modeling · 16. März 2018
This post describes approaches how to virtual relationships between tables can be established using the DAX function TREATAS() and also approaches how to create physical relationships instead.
21. Februar 2018
A gentle introduction to some "basic" concepts of DAX explained for the Year-To-Date calculation, explaining "Filter Context" in my own words. No matter if you use Microsoft SSAS Tabular or Power BI