Home » Uncategorized

Calculate and Format Durations in DAX

An important thing to know about dates and times in Power BI (and Excel PowerPivot) is that they are really just integers and decimals, respectively, behind the scenes. All dates and times in Power BI are relative to…

Read More »

Easily Create and Modify Custom Functions in Power BI

Custom functions are a great feature available in the query editor (Power BI or Excel), and allow you to simplify your code and/or re-use it to save time across multiple files/models. Power BI provides the Combine & Transform…

Read More »

445 Calendar with 53-Week Years

Many businesses operate on a standard calendar so that each fiscal week/month/year begin and end on the same day of the week, making YOY comparisons easier. A 445 calendar is one example, in which each quarter is comprised…

Read More »

No Sort Date Tables!

We've all been there. You go to create your visual with Months on the axis and you see April, August, December … and realize you forgot to create Sort By columns. One way around that is to use…

Read More »

Get Data From SharePoint Lists … But Fast

SharePoint lists remain a convenient way to store data. However, get data from SharePoint lists with lots of items can be frustratingly slow. The updated SharePoint list connector improved things, but not completely. The video below walks through…

Read More »

March Madness With Dataverse For Teams

A few years ago, I wrote a March Madness article on PowerPivotPro that used Excel as the data source (here). With the NCAA tournament being hosted in Indianapolis this year, I decided to revisit that post and make…

Read More »