Data historians are used throughout industry for mass-long term storage of time series data. There are a number of historians on the market with varying popularity but one thing they tend to have in common is their lack of integration options to popular visualisation tools such as Microsoft Power BI. Until now....

Today I'm going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent.

Final reminder: Kudos for the "Ask Arun Anything" event will be frozen on February 21st at 3 PM Pacific Time, so make sure to Kudo the announcement post with more details now!

TOPN is an amazing DAX function to use in Power BI when you want to apply some internal ranking logic to your calculation. We can use TOPN instead of RANKX as the filtering function and create some additional context or additional filters based on a ranking. This makes TOPN a really powerful function that makes complex calculations and extracting complex insights relatively seamless. 

In this post, we’re going to explore the TOPN function, and we’ll go over when and how to use it. TOPN has several usages within our reports to get the insights we want to showcase. 

Power BI supports Direct Query and, when the datasets are huge, the user prefers to go for the direct query. Not all is functionality available in Direct Query Mode. In the last article, we have discussed how time intelligence works well with Direct Query. In this article, we will explore more complex measures.