Category: Uncategorized

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 7 – Batch change of objects in the model

You could always modify your model with 1 change at the time. What if there are 200 things wrong in your model?

Today’s challenge is to move all Sales-measures from DimCurrency table to FactInternetSales table. Describe how you can do that efficiently?

Someone has created our sales measures to wrong table. Please move them to FactInternetSales.

Model can be found at: https://material.qumio.com/christmas2025/day7.zip

You can return the answer at: https://forms.office.com/e/Qe4KN1pkes 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.

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 6 – Independence day challence

This is special! Today is Finland’s Independence day. It is public holiday in Finland. President is having a reception at his castle etc. Also Finnish defence forces promote persons in reserve. Finland has one of the biggest reserve army’s in Europe. The size of the reserve is currently around 800 000 soldiers and it is about to grow to 1,2 million. Defence forces promote soldiers to new ranks if their task requires that and/or they are suitable for new task. Promotions are public information after they have been announced.

Today’s challenge is to visualize this data into map. I first thought that we would also take the PowerQuery part but that is a bit large task. It is not difficult but as a challenge just takes too much time. So I did a prebuilt dataset for you. You can download it from here: https://material.qumio.com/christmas2025/day6.zip

Your task is to visualize new promotions into map with some meaningful way and celebrate Finland’s independence day with others!

As an example I did personally this:

Publish to web report is here: https://app.powerbi.com/view?r=eyJrIjoiODcyMjA5NTUtNjEzYS00MGIyLWI3MjQtMDI3ZTUyMWNjMzJiIiwidCI6IjhjNmM1OWU2LWZmMDAtNGYxMS1hMjgxLTRhMThjNzFkOWM5OSIsImMiOjh9

You can return the answer at: https://forms.office.com/e/LKyrfu3pf2 You have until end of day 7 to answer. As today is visualization task and there is no file attachment option on the return, just describe the answer.

Happy independence day.

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.

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 5 challenge

Power BI Roles to protect data! Today your task is to modify the report so that same report could be used for “Silver color sales people” and “managers”. This means that we need 2 different roles. 1 role that can see all the data and one that can only see sales for the Silver products.

Answer with the role definitions described.

You may download template pbix document from: https://material.qumio.com/christmas2025/day5.zip

You can return your answer at: https://forms.office.com/e/JTKYxpejGG You have until the end of 6th of December to 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.

ower 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 4 Challenge

Today’s challenge is simple: Create visual calc that shows the percentage growth of the sales month-over-month. So Compare Sales from February to sales of January and result is the growth percentage.

Yesterday we used measure in the model. Today you cannot use model but have to use Visual Calc!

You may download template pbix document from: https://material.qumio.com/christmas2025/day4.zip

You can return your answer at: https://forms.office.com/e/1E2fCzd4pt You have until the end of 4th of December to 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.

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 3 Challenge

Today’s challenge is simple: Create measure that shows the percentage growth of the sales month-over-month. So Compare Sales from February to sales of january and result is the growth percentage.

Create measure in the model.

You may download template pbix document from: https://material.qumio.com/christmas2025/day3.zip

You can return your answer at: https://forms.office.com/e/UbagSKcFuL You have until the end of 4th of December to 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.

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 2 Challenge

Business user has created Sales and Tax report. It is lagging Year-to-date functionality. Currently report shows just normal Sales per month figure on the YTD-chart.

Your task is to modify Datamodel in a way that year-to-date calculation for Sales and for Taxes would work.

There are few restrictions:
You are not allowed to change PowerQuery part. You are not allowed to change relationships.

Business user has decided to use 2 independent date dimension tables and it should remain like that.

Can you make both YTD calculations work?

Power BI Datamodel in this exercise can be found from: https://material.qumio.com/christmas2025/day2.zip

Please return information what you did to change to make sales on the left to work and what you did on the right to make Taxes to work!

You can return your answer at: https://forms.office.com/e/UbagSKcFuL You have until the end of 3rd of December to 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.

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 1 Challenge

We start with very easy warm-up! Please read following instructions and submit your answer!

To begin, please download the following Power BI Desktop file: (link: https://material.qumio.com/christmas2025/day1.zip )

The Sales department has created a report intended to display sales by currency name. However, the report is not showing sales correctly.

Your task is to identify the issue with the report and submit your answer at: https://forms.office.com/e/PcFrgdrr3k Remember: No later than end of day december 2nd.

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.