SWITCH TRUE FUNCTION FOR DATE BETWEEN DATES TO PERIOD 1

[Neill_]

I'm trying to add a column via DAX to find a single date between date ranges e.g. April 1st - April 30th 2020 and make this value Period 1 and so on...

Here's what I have so far:

Column = SWITCH(TRUE(),'looker_views lkr_Audit'[Audit_DateTime],

DATE >= DATE(2020,04,01) & DATE <= DATE(2020,04,30), "Period 1")

However it keeps giving me the error: Failed to resolve name 'DATE'. It is not a valid table, variable or function name.

So I changed this to a table i.e.

Column = SWITCH(TRUE(),'looker_views lkr_Audit'[Audit_DateTime],

'looker_views lkr_Audit'[Audit_DateTime] >= 'looker_views lkr_Audit'[Audit_DateTime](2020,03,02) & 'looker_views lkr_Audit'[Audit_DateTime] <= 'looker_views lkr_Audit'[Audit_DateTime](2020,03,30), "Period 1")

and the error comes up as:

The function used in this expression is not a valid function nor the name of a measure.

Thanks for any help offered

[harshnathani · Accepted solution]

Hi @Neill_

Column = SWITCH(TRUE(),'looker_views lkr_Audit'[Audit_DateTime],

DATE >= DATE(2020,04,01) & DATE <= DATE(2020,04,30), "Period 1")

 

DATE is a DAX  function which takes in value DATE(YEAR, MONTH, DAY).

https://dax.guide/date/

 

Try this

Column =
SWITCH (
    TRUE (),
    'looker_views lkr_Audit'[Audit_DateTime]
        >= DATE ( 2020, 04, 01 )
        && 'looker_views lkr_Audit'[Audit_DateTime]
            <= DATE ( 2020, 04, 30 ), "Period 1"
)

Regards,

Harsh Nathani