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
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.
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
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...