The world of DAX is on fire with the release of new functions at the end of 2022. Many posts on various blogs have appeared showing many scenarios explaining the new functions.

Most articles try to explain the functions. This article will overlook that and will try to compare how time intelligence functions respond with traditional code compared to the new DAX functions to solve those classic date scenarios.

Scenario: 

Sometimes when we create a report, we may want to implement a complex data sorting in visuals according to multiple ranking rules. This is not easily done by sorting by a single column or ranking by a single expression. We will need some DAX techniques to get there.

In this article, we want to sort car brands in a table visual according to several rules. And when a ranking is selected, a dynamic display includes the two car brands prior to the selected ranking.

Scenario:

In this article, we'd like to achieve a scenario that distributes a table's data into two visuals for displaying while still filtering them with a single slicer.

The detailed requirements are: Create a report with two table visuals and one slicer visual. Two table visuals are created with the same table fields but the data that showed is different, e.g. each table visual could only display half of the data. And when we select items in the slicer, two table visuals will render the data according to the selections.