Data Modeling · 06. Juni 2018
This post shows how a dynamic member called Other can be used for Data Visualizations in Power BI in addition to the common requirement of the visualization of the TOP N or BOTTOM N members. A solution is used that utilizes a combination of data modeling and DAX.
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.
Power BI · 25. Februar 2018
Using Power BI, Azure SQL, Microsoft Flow to analyze what's going at SQLKonferenz 2018
Power BI · 22. Februar 2018
Using Power BI, Azure SQL, and MSFT Flow to analyze what's going on at sqlbits2018
21. Februar 2018
Often we use the Power of DAX statements to create complex calculations that provide tremendous insight into our data. But sometimes there are calculations that seem easy from an Excel point of view, but not possible in DAX. Excel provides the great possibility to create formulas referencing other cells or even ranges that reside in remote spreadsheets. One kind of this calculation type is the iterative application of an interest rate over a timeseries to an investment where the amount of...
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
21. Februar 2018
I started my writing on wordpress, as soon as I realized that my wordpress presence didn't support iframes created by the "Publish to Web" feature of Power BI I had to look for another place and found docs.com, unfortunately some time ago I was informed that docs.com is deprecated. So I had to look for another place to be. Suddenly I had to learn some strange new things as ANAME and similar stuff :-) It took me some time to find a new harbor for my data musings. Over the next weeks I will try...