Forum Discussion

Sab's avatar
Sab
Helper V
1 year ago
Solved

UNION returns strange dates

Hello!   I am a table with around 400k rows (Sales), and another table with 15k (sales Current Month).    As you can see from the screenshot, the dates are normal in the first two tables, and whe...
Need Help
  • Sab's avatar
    Sab
    1 year ago

    thank you for your replies, I found the 'issue'!

     

    It was a column which for whatever reason was misplaced compared to the same column in the other table. 

     

    In Power Query they were properly ordered, but after loading one of them went off one position! I tried to reorder that column in Power Query by sending it to the beginning (in both tables), didn't work! I had to get rid of it and after that, the dates look fine. 


    Thanks again for your replies!

Sab's avatar
Sab
Helper V
1 year ago

thank you for your replies, I found the 'issue'!

 

It was a column which for whatever reason was misplaced compared to the same column in the other table. 

 

In Power Query they were properly ordered, but after loading one of them went off one position! I tried to reorder that column in Power Query by sending it to the beginning (in both tables), didn't work! I had to get rid of it and after that, the dates look fine. 


Thanks again for your replies!