Forum Discussion

Jawed's avatar
Jawed
Icon for Helper III rankHelper III
8 years ago

Convert text to number

Hi everyone,   I am new to Power BI and this is my first attempt at uploading my budget and actual numbers. Because my budget is columnar, I needed to use the "Unpivot Column" option to sort out th...
Need Help
Jawed's avatar
Jawed
Icon for Helper III rankHelper III
8 years ago

Thank you. I will have to run some forensic tests to clear out the data. Probably worth to round the numbers in excel to ensure there is nothing hidden. Does it make any difference if the zero appears as (0) or (-)?

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

No, the number format (0 or -) in Excel makes no difference for Power Query.