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:
SELECTCOLUMNS
Aggregation of two tables with the same structure
A frequent and easy to solve scenario is one in which we find ourselves with two tables with the same structure that we want to add according to some field. Let's see what it would be like. We assume that we have already obtained the data and we have loaded in Power BI the two tables that, in this case, contain sales information:
