Posts filed under Intermediate

Creating a MTD/QTD/YTD Time Intelligence Slicer in Power BI

Video by: Reid Havens

Part one of four in a series. Learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer in Power BI. The end result will perform faster and create a better user experience versus creating lots of unique time intelligence DAX measures.

RELATED CONTENT 🔗

Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods

Download Report From The Blog Files Page

Return Custom Error Message for Any Issue in Power Query

Video by: Reid Havens

Learn how to return custom error messages whenever any applied step in a Power Query query fails. More info about the m code function used to achieve this can be found below.

https://docs.microsoft.com/en-us/powerquery-m/error-record

Download Report From The Blog Files Page
Posted on January 7, 2020 and filed under Intermediate, Power Query.

Multiple Ways to Apply Field Based Conditional Formatting

Video by: Reid Havens

Learn about three different color codes that can be applied to field based conditional formatting in Power BI desktop. Special thanks to Will Thompson on the Power BI team for showing me these options.

Download Report From The Blog Files Page
Posted on December 17, 2019 and filed under Intermediate, Power BI Features.