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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors