This week, I got an interesting question about Power BI: “Can I format a specific cell or row in a table or matrix?” My answer was yes and I thought it could be a great blog. Let’s say, you need to format the Sales Amount for all countries as a whole number, except for Australia. … Continue reading Power BI: How to format a specific cell or row in a table or matrix?
On this post, I will talk about SQLSaturday. I believe some people don't know what SQLSaturday is and I am so happy to explain it 😊 SQLSaturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through … Continue reading What is SQLSaturday?
Hi All, Power BI is a powerful tool to analyse data and share insights, that’s the reason this month I decided to create a quick Power BI report to show an insight of all releases since July 2015. I really enjoy working with Power BI and I appreciate how Microsoft Power BI Team listens to … Continue reading Power BI Features Insights
This year was my second year at PASS Summit and I can summarize these five days as inspiring, connecting, sharing and learning. I have been interviewed by PASS TV, where I had my 3 seconds of fame 😊 and it was a great experience to talk about this event. https://www.youtube.com/watch?v=JDx70lt2wBQ&feature=youtu.be If you have a chance … Continue reading 3 Seconds of Fame & Experience at PASS Summit 2017
Last week, I received an Excel file with hundreds of sheets and I had to import it to Power BI. The Excel spreadsheet had one sheet per day, as below: When I tried to import it, I realized that a lot of people may have the same requirement and I decided to write this post, … Continue reading Power BI – Importing Multiple Excel Sheets
In the previous post (Working with Date – Part I), I wrote about calculated column for month and year and in this post I will explain how to work with day and week formats. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Continue reading Power BI – Working with Date – Part II
I have been working with Power BI for few years and quite often someone asks me questions about Date functions in DAX (Data Analysis Expressions), that is the reason I am writing this post. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Continue reading Power BI – Working with Date – Part I