Power BI is celebrating its 10th anniversary! To mark this milestone, I invite you to participate in the Power BI Christmas and holiday season Calendar. This special event features 24 unique challenges, each designed for you to solve and enjoy throughout the season.
A new challenge will be released every day, starting December 1st and continuing through December 24th. Each day presents a fresh opportunity to test your Power BI skills and creativity.
At the conclusion of the event, a winner will be selected from among the participants. Microsoft Finland has generously offered a prize, with further details to be provided soon.
Throughout December, we will maintain and announce a leaderboard, showcasing participants’ progress. Correct answers will also be shared. You will have two days to solve each puzzle; for example, the puzzle released on day one will close at the end of day two.
Day 8 – Reusable code in the model
Today’s challenge builds on top of the Day 7 challenge. We have a lot of Sales Measures in the model. Currently they are all similar and exact same code. In future Business users want that Sales10 = SUM(FactInternetSales[SalesAmount])*10 and Sales11 = SUM(FactInternetSales[SalesAmount])*11. So each Sales measure has a multiplication part where it is being multiplied with the number of the measure. Sales45 multiplies with 45, Sales73 multiplies with 73 etc…
Day after tomorrow they could change their mind again and want that to be Sales10=SUM(FactInternetSales[SalesAmount])*(10/2) and Sales11=SUM(FactInternetSales[SalesAmount])*(11/2).
Abstract that multiplier part so that it can easily be changed whenever needed. So Solution should not be global search and replace where you change hundreds of places the multiplier but a structure which abstracts that so that it is easy to change in one place.
Describe your solution in answer. You have until wednesday 10th to answer! So let’s make it so that we have 3 days time to answer as I can see people answering older questions still today.
Model can be found at: https://material.qumio.com/christmas2025/day8.zip
You can return the answer at: https://forms.office.com/e/RGQCm6v4f6 You have until end of day 8 to answer. As today is visualization task and there is no file attachment option on the return, just describe the answer.
This Holiday season / Christmas challenge is provided by Vesa Tikkanen and is not linked to Microsoft as company. I just want us to have a puzzle every day going towards the 24th of December. This is pure community effort without any business relations behind. As such I try to do this as professional as possible but please remind that this is just for us to have fun. Microsoft finland has promised some swag as a prize but they are not related to winner pickup process neither they get any details of attendance. Information regarding attendance is not being used in any other thing than picking up the winner. So no marketing, no contacting just Power BI puzzle every day.