Forum Discussion
Variation 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...
So based on the picure in my previous post, what result are you expecting?
The calculation is ok but the data in the source files is like this :
| type | arrival | departure |
| dog | 01/01/2025 | 02/01/2025
|
cheers
That'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.