Data & Analytics
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, … Read morePower BI – Importing Multiple Excel Sheets
Every month Microsoft releases Power BI updates, which is great as new features are added to Power BI. In this post, I would like to share Power BI previous versions. Since January 2016, I have tried to keep a copy of all Power BI versions, so if anyone needs to use a previous version you … Read morePower BI previous versions
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 … Read morePower BI – Working with Date – Part II
There are a couple of ways in Power BI to create a chart to show percentage and I am writing this post to show few different ways to accomplish it. I am using a few tables from AdventureWorks 2016 CTP3 database, as below: For testing propose, I will use Line Total (Sales Order Detail Table) … Read morePower BI DAX Percentage
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 … Read morePower BI – Working with Date – Part I