Forum Discussion
Load& Combine + Unpivot
Hi ahmadhlawa ,
Check this file: Download PBIX
I've imported the data using FOLDER as connector, edit the Transform Sample File:
1 -> Unpivoting the data
2-> This code allocates the dates in the correct order.
3 -> Filter out the Column1 leaving the CODE values out.
4 -> Remove the Attribute column.
The last step is to pivot the dates using the values and don't aggregate them.
I hope it helps.
camargos88 thanks but it gives me the below result. for each source
however, souce 1 contains values from 1 May20 till 1 Mar21, and source 2 contains values from 1 June20 till 1 April21.
kindly referring again to the combined view in my post as the required output (red cells means month column should apear with a zero value).
Hi ahmadhlawa ,
Have you checked the file ?
I've created this scenario with 3 files, when it doesn't have dates, it's null (can be replaced to 0).
camargos88 your file looks fine, but i don't have the sources on my PC, so can't trace the steps.
do you do those steps to the sample file (from your screen shot i can't see the "Source name" column)?
what i tried is, first i combine all files, then unpivot them, then put the functions you mentioned.
if you do it to the sample file can you please elaborate how can i do that?