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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Switch function with between two dates conditions

Hello all, 

 

Objectif of my code : Assign a predetermine period identificator to a specific date 

 

Scenario : I have a data source from a Sharepoint list , simple one Title and a date

 

I am using the switch function and for some reason the conditions I set for my function are never met, 

here is the very simplified code I believe this as to do with the date format but Im at a lost and would love some help, 

 

Capture1.PNG

 

 

Thanks in advance guys !

1 ACCEPTED SOLUTION
Anonymous
Not applicable

This was a simple date format error, 

 

it was fixed by putting the date in the date() fonction, 

Cheers, 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

This was a simple date format error, 

 

it was fixed by putting the date in the date() fonction, 

Cheers, 

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.