Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

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

 

 

View solution in original post

1 REPLY 1
harshnathani
Community Champion
Community Champion

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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors