ADDMISSINGITEMS
The ADDMISSINGITEMS function adds to a calculated table created by the SUMMARIZECOLUMNS function the rows that have not been included because they represent null values.
GENERATEALL
The GENERATEALL function is similar to the GENERATE function: It returns a table formed by the Cartesian product of all the rows of the first table and the rows of the second table after being evaluated in the row context of each of the rows of the first one.
Creating a calendar
One of the most frequently asked questions regarding the calendar required to use time intelligence features is, is it better to create it external to Power BI? Or in the query editor? Or maybe with DAX?
In this scenario we are going to create a complete calendar in DAX, including the number and name of the month, quarter, day of the week, etc.
KEEPFILTERS
The KEEPFILTERS function allows modifying the behavior of the CALCULATE and CALCULATETABLE functions so that the referenced filters do not replace the existing ones in the current context, but are added to it.
EARLIER
The EARLIER function is used on calculated columns and allows access to the value of a column (of the row being analyzed) in nested calculations. In most cases it can be said that the EARLIER function returns an access "to the current row".
Unlike the EARLIEST function, it allows you to specify the level of recursion that it refers to.
Adding data from one table to another with no relationship between them
In general, when we want to work with data distributed between two or more tables, we start from a data model in which the tables are related to each other by means of "relationships" that involve a key field at the ends of the tables. But it is not always necessary for these relationships to exist.
In this scenario we start from a table of countries:
Calculation of the number of days between purchases
We start from a list of sales (Sales) in which, for example, the customer identifier and the dates of the purchases are indicated:
GENERATE
The GENERATE function returns a table formed by the Cartesian product of all the rows of the first table and the rows of the second table after being evaluated in the row context of each of the rows of the first one. Or, in other words, for each of the rows in the first table, a row context is created that is applied to the second table before the join is performed.
ISSUBTOTAL
The ISSUBTOTAL function returns the logical value True if the corresponding row contains a subtotal for the column indicated as an argument.
