Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SWITCH TRUE FUNCTION FOR DATE BETWEEN DATES TO PERIOD 1

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
change
dates
Filter
switch
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous

     

     

    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

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous

     

     

    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