Hello Friends, This is a sample interactive dashboard prepared from the NAV 17 Data Warehouse. Let me know if you like it & would like to explore the sample dashboard.  

The equal allocation of budget is the technique you use to compare budget information at the different granularity with other data such as Sales or Discounts etc.using Power Query. They are an extension of the handling of different granularities in Power BI using the DAX as I discussed in my last blog. In this article, …

Evaluation context is the heart of the DAX language in Power BI ¬†and it is essential to learn them in order to understand the internal behavior of the calculation engine in tabular data models. In this article, We will closely understand how calculated columns are created, its relationship to the row context and the EARLIER …

It is really common scenario in the BI data models that you have to handle the data of the different granularities when at least two tables contain different levels of information stored. For Example, you have a Revenue Table that records data at a day granularity and Budget table with data stored in the monthly …

  IF..THEN..ELSE conditional programming logic is most common in all programming languages and it is one of the powerful weapon to handle the complex calculations. Those familiar with SQL, CASE Statements are the one of the way to achieve the end results. In Power BI, DAX has its own syntax and it is using SWITCH/Nested …

One of the most common calculations performed in data analysis is to compare some number to a comparable number for a different time period. Calculations that make comparisons to last month or to the same period from a year ago are very important for any business intelligence tool. DAX includes more than 35 functions expressly …

The DAX language in Power BI has a function RANKX that returns a ranking of a number in a list of numbers for each row in the Table argument. RANKX is a scalar function and it is also an iterator. The RANKX function can optionally take a Value argument that represents a scalar value whose …

  Power BI is the new product offering from Microsoft in the fastest growing self-service BI market today with the user base of more than 5 million active users worldwide. Power BI suite of products were initially released into the BI Market in the start of 2010 under the name of Power Pivot in Excel. …