DAX

2024 Week 35 | Power BI: Overlapping histogram with normal distribution curve

Power BI, Workout Wednesday / By

Introduction Overlapping histograms with normal curve overlays are used to compare the distribution of a numerical variable across different groups such as male and female body mass. With this we can glance the central tendency, spread, and skewness of the data within each group and also how well the data follows a normal distribution. The …

2024 Week 35 | Power BI: Overlapping histogram with normal distribution curve Read More »

2024 Week 31 | Power BI: TOPN and Others

Power BI, Workout Wednesday / By

Introduction This week’s challenge is brought to you by Guest contributor Roland Szirmai. Requirements Download data from SQLBI’s blog2. Create a Sales YTD and Sales PYTD patterna. Don’t forget the ShowValueForDates calculated column and the DateWithSales measure 3. Confirm that the Sales YTD and Sales PYTD measures are correct4. Replicate the TopN vs Others measures …

2024 Week 31 | Power BI: TOPN and Others Read More »

2022 Week 44 | Power BI: Customer Lifetime Value

2 Comments / Power BI, Workout Wednesday / By

Introduction This week, our challenge is to calculate customer lifetime value by quarter using DAX.  This is an advanced challenge so buckle up! As I was working on my challenge for week 44, I stumbled upon the drafted challenge for Tableau on the same week.  The Tableau challenge was… you guessed it… developing a chart …

2022 Week 44 | Power BI: Customer Lifetime Value Read More »

2022 Week 32 | Leverage Field Parameters in Measures

Power BI, Workout Wednesday / By

Introduction My name is Spencer Hamilton, Analytics Consultant with phData, and I’ll be guest hosting this week’s challenge! For the challenge, we’re going to look at one of Power BI’s newer features, Field Parameters, and create some calculations that dynamically change based on the selected parameter value. In this specific example we’re looking at Sample …

2022 Week 32 | Leverage Field Parameters in Measures Read More »

Screenshot from Power BI Workout Wednesday 2022 Week 18

2022 Week 18 | Power BI: Remake this Tableau budget burndown chart

Power BI, Workout Wednesday / By

Introduction For the month of May, we are remaking Tableau visualizations with Power BI. Although the visuals made by the two tools may be similar, the calculations and formatting options are a bit different. This makes some things easier in one tool compared to the other. If you use both Power BI and Tableau, feel …

2022 Week 18 | Power BI: Remake this Tableau budget burndown chart Read More »

2022 Week 11 | Power BI: Project Budget Tracker

1 Comment / Power BI, Workout Wednesday / By

Introduction Your challenge this week is to create a Project Budget Tracker leveraging the IT Spend Analysis example dataset available to everyone in Power BI Service.  We decided to keep the project management theme going this week with this take on tracking how your project is following the budget.  If you did not do last week’s challenge, I …

2022 Week 11 | Power BI: Project Budget Tracker Read More »

A power bi report that calculates contrast ratio between two colors

2021 Week 46 | Power BI: Create a Color Contrast Calculator

Power BI, Workout Wednesday / By

Introduction This week we are continuing our design theme by making a report about report design. Color is a very important element in report design. Color contrast is not only important for accessibility, it’s also an element of visual hierarchy. You can also use color contrast as a way to make elements on your report …

2021 Week 46 | Power BI: Create a Color Contrast Calculator Read More »