Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone, i would like to get some help, but first I will give some context (the names are in French sorry)
Sem | Date | Nom | Prénom | Matricule | Structure | Durée | Libellé | Créneau Horaire | ACH160 (1ere incluses) | Urgences | RETAB | DIT | DAN | A analyser EPOD | A régulariser | MHS Point coupé | ACH | DIT | INTER APPAREILS | |||
29 | 18/07/2023 | GUEZZEN | INAYA | I56375 | Clermont Ferrand | 08:00 | 11:45 | 03:45 | Atelier sur site | 08:00-11:45 |
So here you have an exemple of my source for my BI, i have around 4000 lines like that
The idea is to sum the "Durée" (time spent) by day in order to understand how many hours were done each day (the cross is use the select the type of action realised), first i created a new table with days from 01/01/2023 to 12/31/2025 linked with the origin table on the Dates and then i wrote this program :
and with the filter
I tried things like creating a new table with only the names and give it the priority over the others tables but nothing work
the thing strange here, it's when I create a new column with this program :