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...
Hi,
PBI file attached.
Hope this helps.
hi,
it's not ok, i've only one raw with arrival and departure date. so it's not what expected
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.