Forum Discussion
Power Query Drops Leading Zero
Dear community, Hope my message finds you well! I have 2 data sets which contain 1 fact table and 1 dimension table. Both data sets are CSV files and all columns are formatted with type "...
Hello guys,
Anonymous and Jimmy801
Sure, here's link to the files. I uploaded both XLSX and CSV version of the files.
https://drive.google.com/drive/folders/1g8SXAaKHlYiJhITkfZ0e6lu3prv9gd-D?usp=sharing
Once you request access i will give it immediately, if I am not sleeping, which won't happen for the next 10-11 hours.
In the Fact table you will find region, transaction number and amount.
In the dimension you will find Transaction number and BU (business unit).
The relationship between both tables is based on the transaction number column.
The number of the transaction with the missing leading zero is originally 020874, but in the query editor is 20874.
I tried both Power BI and Excel, the results were the same.
All due respect,
Atanas