RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays

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[…]

Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns

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[…]

Draw Slope Chart in Power BI: Part 8

Slope chart can be used for comparing data between two different time periods. it is a very easy way to depict the difference between to time, two elements or any other two attributes. The slope charts can be used to study the correlation between variables or to study the change in the same variable between Read more about Draw Slope Chart in Power BI: Part 8[…]

Taking a byte out of U-SQL

I recently had a requirement to combine a set of approx. 100 CSV files into a single file and encountered an interesting problem along the way. The files all had the same simple structure which was 2 columns.  I thought this would make a pretty straight forward exercise – until I started processing the files. I Read more about Taking a byte out of U-SQL[…]

New Series of Time Series: Power BI Custom Visual (Part 7)

In the last three parts, I have explained about the time series R custom Visual we have in Power BI. as you remember we have 3 main time series chart in Power BI store (see below): Decompose of time series (trend, seasonality and irregular components). the two other custom visual help us to do forecasting Read more about New Series of Time Series: Power BI Custom Visual (Part 7)[…]

Create a Date Dimension in Power BI in 4 Steps – Step 1: Calendar 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[…]

New Series of Time Series: Power BI Custom Visual (Part 6)

In the last post, I have explained how to do time series forecast using “Exponential Smoothing” approach in Power BI. I start to explain the main parameters that we need to set up. The main concepts behind of most of these parameters have been explained in previous posts (Post 4, Post 3, Post 2, and Read more about New Series of Time Series: Power BI Custom Visual (Part 6)[…]

Solving DAX Time Zone Issue in Power BI

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[…]