In last two steps you learned how you can create a date dimension that has calendar columns, and fiscal columns. In this step we are going to look at how Power Query can be leveraged to fetch public holidays live from APIs, and add that information into the date dimension. This step shows the importance Read more about Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays[…]
In step 1 of creating date dimension I explained how to create the base query with calendar columns. In this post I will explain how to add fiscal columns calculated in the date dimension. Many of business reports generates on fiscal year, fiscal quarter, and fiscal period, so having fiscal columns is important part of Read more about Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns[…]
I have written multiple blog posts so far about creating a date dimension. However, I still get the question about how to create a date dimension. In this series of blog posts I am going to explain in details how you can create a date dimension easily in Power BI (based on Power Query). this Read more about Create a Date Dimension in Power BI in 4 Steps – Step 1: Calendar Columns[…]
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch Read more about Solving DAX Time Zone Issue in Power BI[…]
In this post, I am going to show how we can do time series inside Power BI using custom visual from Office store. First you need to download custom visual from office store, to download R custom visual please follow the below link https://store.office.com/en-001/appshome.aspx?ui=en-US&rs=en-001&ad=US&clickedfilter=OfficeProductFilter%3aPowerBI&productgroup=PowerBI now we are going to download some timeseries custom visuals Read more about New Series of Time Series: Power BI Custom Visual (Part 4)[…]
In the last posts, I have explained the main concepts behind the Timeseries (Post 1) and in the second one a simple forecasting approach name as “Exponential Smoothing” has been proposed Post 2. In this post I am going to show how to do see the error of forecasting and also how to forecast when Read more about New Series of Time Series: Part 3 (Holt’s Exponential Smoothing)[…]
At the time of writing this post; there are already more than 97 custom visuals posted in Office Store. The list includes many interesting custom visuals. However, Infographic Designer is one of the visuals that is not just another visual. This custom visual has some unique features that you cannot see in many other visuals. Read more about Infographic Designer: Not Just Another Visual[…]
In this new series I am going to look at the time series models and how we able to use them for forecasting data. The first need in timeseries data is to have a series of data for years or for some qurdant. imagin that we have a time series data on birth rate from Read more about New Series of Time Series: Part 1[…]
One of the recent features in Power BI Desktop is the ability to create your own custom connector and use it when connecting to the data source. This feature looks just one feature, but it opens doors to many possibilities. With this feature you can write your own custom connector to any types of data Read more about Power BI Custom Connector: Connect to Any Data Sources. Hello World![…]
Previously I have written a blog post explaining two ways of combining data sets with each other; Append vs Merge. In this post I want to explain in details what is the difference between all types of Merge Type and explaining how to choose the right merge (or Join) type. These Merge types are very Read more about Choose the Right Merge Join Type in Power BI[…]