This blog is to explore how to generate cartesian products of rows using DAX in Power BI.
Recently I came across a question about how can you find data pairs, for example flight from port A to B which also has a return flight from port B to A. This blog is to explore how this could be solved using DAX.
Lets say a tour company wants to know how many passengers are travelling between two locations at a given time for a given location. That is, they wanted to know the number of passengers travelling From or To for a given location. For example number of passengers travelling From or To A (i.e. From A to B OR From B to A).
This article explores how to transform task or project management data in Excel, Text or CVS format into a Power BI table.
The Excel data file has three column names in the same cell followed by respective three values in each cell. How can this be formatted as a Power BI data table using Power Query Editor.
Usually running total or cumulative total is calculated based on a date field, like sales date. Recently I was asked whether a running total can be calculated based on month number. i.e. 1 to 12 month number. How can this be done?
Calendar table is created using DAX CALENDAR() function. The requirement is to add an index column of 1 to x to this DAX table. Since it is a table created in DAX you cannot view this table in Power Query / M to add an Index column using M. So how can we add an index column using DAX?
How to filter different types of files from the same folder and combine them into a single table in Power BI?