This article describes how to use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure. TOJSON Converts the records of a table into a JSON text. TOJSON ( <Table> [, <MaxRows>]… Read more
The new calendar-based time intelligence functions offer greater flexibility than the classic time intelligence functions. This article describes the DATEADD parameters for controlling different granularity shifts. DATEADD Context transition Moves the given set of dates by a specified interval. DATEADD… Read more
This article shows how to create a DAX measure that displays information from multiple columns in a business entity or transaction, into a single column of a matrix. Read more
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships. Read more