SSRS Multivalue Parameters in DAX
UPDATE: Microsoft has added support for multi-valued parameters in the DAX Query Designer. Please read the discussion thread below for more info. You can use the approach discussed in this […]
New Search
If you are not happy with the results below please do another search
165 search results for: DAX
Tabular DAX Editor
The Tabular toolset is getting better. One thing that I miss from Multidimensional is the cube script that lets you view all custom calculations in one place so that you […]
New USERPRINCIPALNAME DAX Function
Now that Power BI Desktop supports Row-level Security (RLS), modelers have a little predicament. On the desktop, the USERNAME() function returns the user’s domain login (domain\login). However, when the model […]
Aggregates over Aggregates in DAX
Sometimes, you might run into a scenario that requires an aggregate over an aggregate. Consider the following report: The AvgOrderAmount has a simple calculation: SUM(Sales)/SUM(Qty). This calculation is applied uniformly. The […]
Implementing Qlik-style Variables in DAX
A large publicly-traded organization is currently standardizing on Power BI as a single BI platform as a replacement of Qlik and Tableau. They analysts have prepared a gap analysis of […]
DAX Editor Adds Support for Tabular Default Members
UPDATE 4/24/2019 The new JSON-based Tabular schema doesn’t support extensions so Tabular Editor and BI Developer Extensions (BIDS) won’t work. In my previous blog, I announced a few new features […]
DAX Editor New Features
UPDATE 4/24/2019 The new JSON-based Tabular schema doesn’t support extensions so Tabular Editor and BI Developer Extensions (BIDS) won’t work. As it stands, Tabular (versions 2012 and 2014) doesn’t have […]
Projecting a Scalar Value with DAX EVALUATE Queries
When you work on more complicated DAX measures, you should get out of the Power Pivot or BISM design environment and use the excellent DAXStudio (or SSMS) with the EVALUATE […]
Filtering Tables Dynamically in DAX
Sometimes, your DAX calculated measures might need to filter a table dynamically based on a certain condition. For example, you might have a Type 2 table like this one: ClaimID […]
Finding Duplicates in DAX
A prerequisite for creating a relationship in Tabular/Power Pivot is to have a primary key column in the table on the One side of the relationship. This column must have […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
