Pragmatic Works Nerd News | DAX

Skip to content

Power BI, DAX, Data Analytics

How To Use DAX Query View in Power BI Desktop

In this tutorial, we explore how to use the DAX Query View, a powerful feature in Power BI Desktop, to debug, modify, and [...]

Mitchell Pearson

Mitchell Pearson December 30, 2024

DAX, dax functions

Using X Functions with Summarize to Solve Tricky DAX Problems

In this video, Mitchell Pearson demonstrates how to solve tricky DAX problems using X functions like SUMX and AVERAGEX in [...]

Mitchell Pearson

Mitchell Pearson December 25, 2024

Power BI, DAX

Using Existing DAX Magic to Perform a DistinctX in Power BI

In this video, Mitchell Pearson demonstrates how to write more complex DAX (Data Analysis Expressions) in Power BI by [...]

Mitchell Pearson

Mitchell Pearson October 21, 2024

Power BI, DAX

Dynamic Fiscal Year Date Table using DAX in Power BI

In this tutorial, Amelia Roberts from Pragmatic Works demonstrates how to create a dynamic fiscal year date table using DAX [...]

Amelia Roberts

Amelia Roberts September 9, 2024

DAX, Cheat Sheet, Resources, Free

Unlock the Power of DAX with Pragmatic Works' DAX Functions Cheat Sheet

Are you tired of sifting through endless documentation and online resources to find the DAX function you need for your Power [...]

Mitchell Pearson

Mitchell Pearson December 8, 2023

Learn how to calculate working days in Power BI with DAX, including weekends and holidays. Simplify date-based analytics.

Power BI, DAX, Calculated Measures

Return Working Days in Power BI using DAX

In this video , Mitchell Pearson explores how to calculate the number of working days from a date table in Power BI. He [...]

Mitchell Pearson

Mitchell Pearson October 19, 2023

Power BI, DAX, Date Tables, Power Apps

Power Apps: Display Forms and Last Submit

Just about every Canvas application that gets created uses a form of some kind. There are two types of forms to leverage in [...]

Matt Peterson

Matt Peterson May 27, 2022

Power BI, Power BI Custom Visuals, DAX, Power BI Training, Power BI Report Services, Power BI Functions, Power BI Quick Tips, Power BI Tips, dax functions, time series, dax formulas

Power BI: Time Intelligence Rolling Measures

One of the most powerful features of Power BI when it comes to DAX is a time series analysis. Using pre-defined DAX [...]

Matt Peterson

Matt Peterson June 23, 2021

Power BI, Free Training, DAX, Power BI Training, Power BI Functions, Power BI Quick Tips, dax functions

Power BI: DAX Function USERELATIONSHIP Explained

In the Power BI Desktop, you are allowed only 1 active relationship between tables in your data model. Many times this is [...]

Matt Peterson

Matt Peterson May 11, 2021

Power BI, Free Training, DAX, Microsoft Power Platform, On-Demand Learning, Power BI Functions, Calculated Measures, Power BI Tips, dax functions, if function, switch function

Let's Get Organized With Power BI

Organization for me is always a priority. When things are not in the right place and I can’t find something quickly I get [...]

Matt Peterson

Matt Peterson April 19, 2021

Power BI, Free Training, DAX, Microsoft Power Platform, On-Demand Learning, Power BI Functions, Calculated Measures, Power BI Tips, dax functions, if function, switch function

Power BI: Use DAX Switch Function to Make IF Functions Easier

The IF function in DAX is a very popular logical function. It will perform a logical check on a value expression and produce [...]

Matt Peterson

Matt Peterson April 13, 2021

Power BI, Free Training, DAX, Microsoft Power Platform, On-Demand Learning, Power BI Functions, Calculated Measures, Power BI Tips

Power BI DAX: Running Totals Using Variables, CALCULATE, and FILTER

Recently after a private training, I had a follow-up email from one of the participants. He asked if there was a way to [...]

Matt Peterson

Matt Peterson April 5, 2021

Power BI, Free Training, DAX, Power BI Report Services, On-Demand Learning

Pizza and DAX are my Love Languages

Matt Peterson

Matt Peterson November 9, 2020

Power BI, Free Training, DAX, On-Demand Learning

Avoiding Unwanted Outcomes using Date Columns

Matt Peterson

Matt Peterson October 6, 2020

Power BI, DAX, Azure Every Day, Row Level Security

How to Test Dynamic Row-Level Security in Power BI

Want to learn how to test dynamic row-level security in a Power BI Desktop file? In a previous post, I showed how to set up [...]

Steve Wise September 23, 2020

Power BI, DAX, Power BI Tips

The Power of CALCULATE in Power BI

Last week in my blog and video I discussed how Power BI could have made my life as a teacher much easier. It is not that [...]

Matt Peterson

Matt Peterson June 9, 2020

Power BI, DAX, Azure Every Day, Row Level Security

Dynamic Row Level Security in Power BI

Interested in learning how to set up row level security (RLS) in Power BI when you have varied criteria? In this post I’ll [...]

Steve Wise May 12, 2020

Power BI, DAX, Power Query Editor, Power BI Quick Tips, Calculated Measures, Measures

Time Saving Quick Tips for Power BI Beginners

Up-Up-Down-Down-Left-Right-Left-Right-B-A This was a series of commands, a holy "code" that I whispered to myself over and [...]

Matt Peterson

Matt Peterson May 11, 2020

Power BI, DAX, Date Tables

A Helpful DAX Function for Power BI Date Tables

Data, especially in the time of quarantine, can make you look REALLY good on paper. Or, on the screen I should say-- or in [...]

Matt Peterson

Matt Peterson May 4, 2020

Power BI, DAX, Power BI Functions, Consolidate Data

Relating Related Tables in Power BI to Baseball (I Miss Sports)

I miss sports. In particular, I miss baseball. Between learning more Power BI functions and the ins-and-outs of DAX, I've [...]

Matt Peterson

Matt Peterson April 27, 2020

1 2

❯

8860e555-b413-4feb-99b7-320c0e09f43e-removebg 1

Vector20

free events

Learn With The Nerds

A free virtual series bringing thousands of tech professionals together for a few hours covering an array of data analytics and cloud topics.

Join Now!