Pragmatic Works Nerd News

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 May 11, 2021

Power BI, Free Training, Power BI Desktop, Power BI Monthly Digest, On-Demand Learning, Power BI Quick Tips, Power BI Updates, power bi bookmark

Power BI: Use Bookmarks To Make It Easy For End-Users To Reset Filters

Slicers are great in Power BI reports because they allow for the end-users to see the data filtered in any way they see [...]

Matt Peterson May 4, 2021

Power BI, Free Training, Power BI Desktop, Power BI Monthly Digest, On-Demand Learning, Power BI Quick Tips, Power BI Updates

Power BI Desktop April 2021 Updates

Another month and another Power BI Desktop update. What does April 2021 have in store? Keep reading. In the April 2021 [...]

Matt Peterson April 30, 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 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 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 April 5, 2021

Free Training, Microsoft Power Platform, On-Demand Learning, Power Apps

Power Apps: Safeguard Deleting Records

Often times after showing how you can delete a record in Power Apps I will see some nervous faces in the crowd. Even if that [...]

Matt Peterson March 29, 2021

Free Training, Microsoft Power Platform, On-Demand Learning, Power Automate, Power Apps

Power Apps and Power Automate: Send Emails and Format Dates

Power Apps is great for allowing users to create new records that get submitted to a data source. A question I normally [...]

Matt Peterson March 24, 2021

Free Training, On-Demand Learning, PowerApps Collections, Power Apps Functions, Power Apps

Power Apps: Sum Function and Collections (Basic and Advanced)

As a former Algebra and Algebra 2 teacher, I dealt with summing up numbers on a daily basis. In Power Apps, we might forget [...]

Matt Peterson March 15, 2021

Free Training, On-Demand Learning, Power Apps, Filtering Records in Power Apps

Power Apps Filter Records For Logged In User

During my training session with Power Apps, I'm often asked if you filter the records shown in a gallery to only show based [...]

Matt Peterson March 8, 2021

Free Training, Power BI Desktop, Power BI Training, Power BI Monthly Digest, Power BI Updates

February 2021 Power BI Desktop Updates

The first update of 2021 is out for the Power BI Desktop program is out. January didn't have any updates, but February made [...]

Matt Peterson March 1, 2021

Free Training, Microsoft, Power Query, Power Query Editor, Remove Duplicates, Merge

Best Practice To Trim Before Removing Duplicates or Merging In Power Query Editor

In last week’s blog, I wrote and did a video about how to remove duplicate records and keep the most recent entry as long as [...]

Matt Peterson February 9, 2021

Power BI, Free Training, Microsoft, Power BI Tips

Remove Duplicates And Keep Most Recent Records in Power BI

A week ago in my last training, I was demonstrating how to get rid of duplicate records when making a dimension table. One [...]

Matt Peterson February 1, 2021

Free Training, Power Automate, Power Platform, RPA

Getting Started With Robotic Process Automation (RPA) Using The Power Automate Desktop

There are a lot of hot phrases you’ve likely heard thrown around during various keynote sessions at conferences over the [...]

Devin Knight January 21, 2021

Free Training, Microsoft, Power Apps, Patch, Create

Create A Record Without A Form In Power Apps Using PATCH

In Power Apps, forms are great to use to submit data to be recorded in your data source. They do not take long to set up and [...]

Matt Peterson January 18, 2021

Power BI, Free Training, Microsoft, Power BI Mapping, Power BI Quick Tips, Power BI Tips

Power BI Maps Tips and Tricks

Matt Peterson January 11, 2021

Power BI, Free Training, BI, Power BI Desktop, Power BI Report Services, Azure Data Architecture Guide, On-Demand Learning

Deleting Is Scary

Matt Peterson December 21, 2020

Power BI, Free Training, Power BI Report Services, Azure Data Architecture Guide, On-Demand Learning

Loading Folders as Data Sources in POWER BI

Matt Peterson December 14, 2020

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

November's Power BI Updates

It’s been another month and thank goodness we are getting closer to the end of 2020! If you like to read about the updates [...]

Matt Peterson December 2, 2020

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

Unique Ask For Drill Through

Matt Peterson November 23, 2020

1 2 3 4 5

... 8 ❯

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

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!

Posts by topic

On-demand learning

Popular articles

Hackathons, enterprise training, virtual monitoring

All Articles

Learn With The Nerds