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 = SWITC...
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

     

     

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