Pragmatic Works Nerd News | Calculated Measures

Skip to content

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, Power BI Custom Visuals, Power BI Training, Power BI Functions, Power BI Quick Tips, Calculated Measures, Power BI Tips, Filtering

Power BI: Understand Filter Context and CALCULATE

Whether you are new to Power BI or have been using it for a while, filter context for visualizations and measures are so [...]

Matt Peterson

Matt Peterson June 1, 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, 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

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!