Forum Discussion
Group by issue
Never mind! There was an extra space at the end of the 2020 values, cleaning the text resolved the problem. Thank you all for your suggestions and time, it is much appreciated!!!!
Hi Anonymous
Replace Null values by 0
I should have mentioned I already tried that, along with replace null values with blank. Replacing with blank resulted in an error, and replacing with 0 did not change the output.
Here is the output from replacing null with 0:
Anonymous , I have couple of question3 here.
1. Even if they are two rows in table. They will shown as one row; if rows values matches in visual when you take sum of balance. So no need group unless you want have grouped table only
2. What is the error you are getting
- I have some further analysis in Power Query that I need them to be in 1 row for. So yeah, I would like to have the grouped table only.
- The error occured when I tried to replace the null values with blank values (""). I removed this portion of the code and I no longer have the error.
For further context, the data comes from Trial Balances and the grouping worked when I was using 2018 (past year) and 2019 (current year) values. The problems started when the the 2020 data was integrated as the current year data, and the 2019 data became the past year data. The file formats of 2018, 2019, and 2020 are identical, and all of the other queries successfully updated to the 2020 values.
Thank you for your reply!
Hi Anonymous
Is your problem solved?
