Forum Discussion
ricod
Helper I
Helper IVariation IN and OUT
Hello i've a folder with xslx files containing cat and dog names. i want from 1st september 2024 calculate the variation of placements. i've tried many thinks with date table or not but i'm not a...
ricodHelper I
Helper IThe calculation is ok but the data in the source files is like this :
| type | arrival | departure |
| dog | 01/01/2025 | 02/01/2025
|
cheers
Ashish_Mathur
Super User
Super UserThat's exactly how i have treated the source. In the Query editor, i have unpivoted the data. Click on Transform data to review the steps applied to your original table.
- ricod
hi, ok i see. i'll try, but on my sources files i have many others columns
- ricod
Hi, it's progressing, i just need to start the calculation of variance from a specific date (i mean, start calculation from 1 septembre 2024, the variance = 0, and after i start calculating arrival and departure)
- ricod
and the calculation must continue if year change (the calculation seem to be reset changing year)