Unpivot Other columns issue in Power Query - Does not unpivot all the data

[Anonymous]

Hi Experts

I am trying to unpivot the Table Unpivot in the sample data based on the first two columns ie. country and Status. When i do the unpivot with the first two highlighted, It does the unpivot but misses out dates in 2024. Basically not all the dates are taken into consideration.

Sample File

https://www.dropbox.com/scl/fi/h63xi0sau5yk4pblhhe86/sample.pbix?rlkey=y2wr0jfvfaoft6peqz3o0tv0f&dl=... 

[Anonymous · Accepted solution]

Here is the solution
https://www.youtube.com/watch?v=TCV-k7xcUGY

[rsbin]

@Anonymous ,

It appears you may have inadvertently attached a different sample file.  There is only one table called FACT Table.

Does not have Country and Status fields.  Has data such as Phone, Virtual and f2f