Report Portal

Usage of dates argument in a row context

Several Time Intelligence functions in DAX use a argument, which has a special behavior because it can be expressed by using both a column reference syntax, a table expression or a Boolean expression. This article discusses how to correctly pass the argument in order to obtain the desired result also in complex expressions. A longer and detailed discussion is available on a blog post written by Jeffrey Wang. From hereinafter we consider just one of the many Time Intelligence functions (LASTDATE), but the same concepts can be applied to all of the Time Intelligence functions that have a argument.

Read more...

Tags: dax, date

 

2007-2015 VidasSoft Systems Inc.