CURRENTGROUP
The CURRENTGROUP function gives access to the group being considered in the GROUPBY function.
Access to the dates of the current context
Assuming we have a calendar table ("Calendar") and a "Date" field containing the dates, we can access the dates involved in the current context through said field. This allows us to access the first day, the last day, etc. of the period involved in the current context using DAX functions and simple arithmetic operations.
Thus, for example, we can access the first day of the current context by calculating the minimum value of the date column with the MIN function, as follows:
LOOKUPVALUE
The LOOKUPVALUE function returns the value contained in the result_columnName column that meets all the criteria specified by the search_columnName and search_value pairs of arguments.
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:
DISTINCTCOUNTNOBLANK
The DISTINCTCOUNTNOBLANK function counts the number of distinct values in a column other than Blank.
CONTAINSSTRINGEXACT
The CONTAINSSTRINGEXACT function returns True if the within_text string included as the first argument contains the find_text text string included as the second argument.
CONTAINSSTRING
The CONTAINSSTRING function returns True if the string within_text included as the first argument contains the text find_text string included as the second argument.
numpy.subtract
The numpy.subtract function subtracts the values of the two arrays involved, element by element. If x1 and x2 are scalars, the result of the subtraction will also be a scalar.
CHISQ.INV.RT
The CHISQ.INV.RT function returns the inverse of the chi-square "right tailed" distribution.
CHISQ.INV
The CHISQ.INV function returns the inverse of the "left-tailed" chi-square distribution function.
