DAX

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

In my last tutorial here, you learned how to import COVID-19 confirmed and death cases from Johns Hopkins dataset to build your own Power BI dashboard using Power Query. In this tutorial, we will go quickly through the DAX measures that will help you gain better analytics capabilities using Power BI time intelligence. To follow …

Learn to configure your Power BI Aggregations table to really increase the speed of your DAX queries. This does NOT require Power BI Premium!

A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. The…

A few months ago, a very interesting question was posted on the Power BI community forum and I had the opportunity to work on it. Finally, I have the time to write a blog post about this so that we…

I came across an interesting request last week from someone who wanted to dynamically control columns shown in a Power BI table visual – based on the values within each table. There are lots …

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter)…

Multiple patterns on how to tackle things with DAX vs with Power Query in terms of column creation and which approach is the most optimal.

Different modeling approaches can speed up performance of your Power BI dataset - albeit with the tradeoff of additional complexity. One situation is where users need to access a very large dataset, but typically apply the same set of filters - resulting in a small subset of rows meeting the needs of most queries. A sliced aggregate approach (implemented in the data model + DAX) can be used to make your models performant where they need to be, but still allow the full range of reporting.

Workarounds…..workarounds…..workarounds. We all build workarounds as necessary until more enterprise-ready functionality is made available. This is true for Power BI Usage metrics across workspaces. We have usage models for each individual workspace but there are several issues with them. you have to copy the model in order to edit it and make it useful you […]

Did you know, Analysis Services (the engine behind Power BI) keeps track of the number of referential integrity (RI) issues in your model? It uses this information to decide if some calculations ca…

If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built fro…

#DAX #PowerBI #RLS #PowerQuery #M Sometimes, we have to deal with incomplete and messy data; of course, following Roche's Maxim of Data Transformation would mean that we will wait until all the syste…

IntroductionThe RequirementsThe SolutionThe Solution ExplainedConclusion Introduction Recently, in an internal Power BI help forum, someone asked if there was a way to force a slicer’s defaul…

This article describes the DAX filter context using a conceptual model based on a visual representation. The filter context is a fundamental concept to unde

Learn how to format and save all DAX measures in a semantic model using semantic link and DAX Formatter API

Showing the path of the selected data point in a native Scatter plot of Power BI can be done with some hacks and some DAX. This article shows one way to do it.

This is it. The way you write DAX changes today with the preview of visual calculations!

VahidDM website has many valuable articles about DAX, Power Query, Data visualisation, Power BI, Power Platform, and Tips and Tricks.

In this final installment of our four-part mini-series on DAX window functions, we’ll be focusing on a new development. The May release of Power BI Desktop has enriched all DAX window functio…

How to create a DAX measure to notify users filters have been applied to a report when there are hidden slicer or filter panels.

Deep dive into Analysis services 2022 new features deep dive part 1: Composite Model and DAX

Support for the DAX UserCulture function in Power BI Premium is now available.

We are excited to announce the initial release of a query performance optimization aimed at processing Data Analysis Expressions (DAX) queries more efficiently, known as “Horizontal Fusion”.

With lo-code we can automate exporting data from Power BI visuals without any REST API knowledge. We need simply copy DAX queries from “Performance Analyzer”, past it in Power Automate inside “run a query against dataset” action . Then we can perform export operation according to our requirements.

If you want to: Present interesting Power BI discoveries to your colleagues Test your DAX Measures, reporting on a very clean Star schema Discover multiple DAX Functions Show different Power BI features by examples Then this Lazy DAX file is for you! It’s a Power BI Desktop file that you can freely download on my […]

easily compare different categories on the same axes

Comparative Analysis by different values in same dimension in Power BI Have you ever wanted to compare metrics between 2 sets of selected values in the same dimension in a Power BI report? For example, let’s say you wanted to compare claims metrics of one hospital or a group of hospitals to another ...

A little #PowerBI tip - want to get a list of columns in a table? Great for documentation!Run the following #DAX query in DAX Studio or Tabular Editor 3. Preface your tablename with '$' and ignore …