Posts filed under DAX

Adding KPI Indicators to Native Line Charts in Power BI

Video by: Reid Havens

Learn how to add various KPI indicators to the native visuals (Line, Area, etc.) in Power BI using a bit of DAX magic.

RELATED CONTENT 🔗

Hiding future dates for calculations in DAX

Download Report From The Blog Files Page
Posted on April 20, 2021 and filed under Power BI, Beginner, DAX, Visualizations.

Fiscal Periods Time Intelligence Slicer in Power BI

Video by: Reid Havens

Part four of four in a series - learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer with fiscal periods in Power BI. The end result will perform faster and create a better user experience versus needing to create many time intelligence DAX measures.

RELATED CONTENT 🔗

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods

Download Report From The Blog Files Page
Posted on March 30, 2021 and filed under DAX, Power BI, Slicers & Filters, Intermediate.

[DAX] Time Intelligence Problems When Using the TODAY() Function

Video by: Reid Havens

Learn about some potential pitfalls when using the TODAY() function in measures or columns when used in certain types of DAX Time Intelligence measures, and depending on how you utilize the PBIX files.

Download Report From The Blog Files Page
Posted on March 2, 2021 and filed under DAX, Beginner.