Basics of Value Structures in M – Power Query Formula Language

A couple of months ago, I’ve written a blog post about Basics of M and explained few basics about this language. In this post, I’m going to the next step and will explain few other structure definitions in this language. In this post, you will learn about Tables, Records, Lists, and how to navigate through ...

Read More

Power BI and R- Timeseries series Part 9- Decompose None seasonal Data

In the last posts, I have explained about some main concepts of Time series. How to decompose time series that has irregular, trend and seasonality components have been explained in: seasonality component decompose). now image we have a dataset that does not have any seasonality also does not show a clear trend. This data is ...

Read More

Dynamic X axis on charts – Power BI

Posted by on Sep 18, 2017 in Power BI | One Comment

A recent post to the Power BI community desktop forums asked if it might be possible to allow a user to make a slicer selection that dynamically updates the x-axis.  The idea would be to present the end user with a slicer on the report page with options of Year, Quarter, Month and Day and when ...

Read More

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

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

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

Power BI Drill Through

Posted by on Sep 3, 2017 in Power BI | 7 Comments

An exciting new feature appeared in the Power BI web service yesterday.  This is the ability to define a report page as a drill through page.  So far I haven’t seen the September release of Power BI Desktop but I’d be very surprised if this wasn’t included in desktop.  But for the next few days ...

Read More

Taking a byte out of U-SQL

Posted by on Aug 31, 2017 in Azure Data Lake | No Comments

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