Sample Dax Guide

Summary

HASONEVALUE: Returns true when there's only one value in the specified column. SUMMARIZE: Creates a summary of the input table grouped by the specified columns. GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table ... ALLCROSSFILTERED: Clear all filters which are applied to the specified table. PRODUCT: Returns the product of the given column reference. PARALLELPERIOD: Returns a parallel period of dates by the given set of dates and a specified interval. PERMUT: Returns the number of permutations for a given number of objects that can be selected from number objects. FIRSTNONBLANK: Returns the first value in the column for which the expression has a non blank value. FACT: Returns the factorial of a number, equal to 1*2*3*…* Number. DETAILROWS: Returns the table data corresponding to the DetailRows expression defined on the specified Measure.