<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">
bg-img11.jpg

Stay Up-to-Date on All Things SQL Server, Business Intelligence and Cloud

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...

Power BI: Drill Through and Drill Down Must Know GAME CHANGER

If you have not taken advantage of the new modern visual tooltip preview feature in your Power BI reports yet you want to...

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...

Power BI: Personalize Visuals Feature

Have you used the personalize visuals feature yet in Power BI?  If not, then you could be missing out.  The Personalize...

Power BI: Small Multiples Visual Preview

Power BI came out with a new preview feature in the February 2021 version of the Power BI Desktop known as small multiples....

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Power Apps: Advanced Filtering and Delegation Warnings

In my last blog and video, I demonstrated how you can filter the records showing in a gallery using a drop-down...

Power Apps: Filtering Made Easy

While conducting training with Power Apps, one of the most common questions I receive from those in attendance is does Power...

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...

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...

bg-img14.jpg

Join Our Blog

Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.

Leave a comment

Posts by Topic

see all

Recent Articles

Popular Articles