Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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,
Thanks in advance guys !
Solved! Go to Solution.
This was a simple date format error,
it was fixed by putting the date in the date() fonction,
Cheers,
This was a simple date format error,
it was fixed by putting the date in the date() fonction,
Cheers,
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 61 | |
| 52 | |
| 47 | |
| 41 | |
| 38 |