Extreme DAX by Michiel Rozema & Henk Vlootman

Author:Michiel Rozema & Henk Vlootman [Michiel Rozema]
Language: eng
Format: epub
Publisher: Packt Publishing
Published: 2022-01-19T16:00:00+00:00

The first argument is TRUE(). This means that the cases in the SWITCH expression are evaluated to determine whether or not they are true. The first option to be evaluated, ISFILTERED('ISO Date'[Date]) in the second argument of SWITCH, examines whether a filter is placed on the day column. If so, the third argument is evaluated and returned.

ISFILTERED requires a direct filter on the 'ISO Date'[Date] column. You should not use ISCROSSFILTERED, since this function would also be triggered when a higher-level column, like Period or ISO Year, is filtered.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.