Home » Uncategorized

Updated – Get SharePoint List Data … Fast

While storing your data in a database is recommended, many citizen developers do not have the access or skills to create databases. As a result, many valuable business solutions are based on top of SharePoint Lists, and all…

Read More »

Time Tables in Power BI

In a previous video, the importance and benefits of splitting DateTime columns into separate Date and Time columns was discussed. For example, a table with DateTime columns of StartDateTime and StopDateTime should be transformed in the query editor…

Read More »

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

Note: A better approach is described in a more recent post. The new version allows for Scheduled Refresh in the Power BI Service, and avoids the issue described in the comments below with duplicate items. See new post…

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 »