Forum Discussion
Complement values to a defined value
Here you go
Hi, dsj8wksnnckk
I have reproduced your problem and was able to solve it.
Need to transform. I am adding the pbix file.
Result:
Hey,
thanks for the assistance.
I'm not quite sure this solution would be applicable. I see one of your steps is transpose table, but my table will have unlimited number of rows (thats what the 3 dots mean on the bottom).
What do you think?
Hey, If you check it again, those were the automated steps that PQ performed. I took a sheet not a table when importing data to PBI PQ. So those were the unnecessary steps.
See below image:these steps are the main ones. I did not use transpose. I loaded the tables and the result is same.
Hey, can you re-upload the file? It was deleted and I seem to have lost it 😞
sure. I will upload it once I get home