Forum Discussion
Entering target data and Setting Dynamic target lines
Thank you so much everyone for all the help . As this was a small table, I tried recreating the issue again by manually entering the data and this time it read as whole number. I was able to make the joins and it works perfectly:)
Hey Greg_Deckler ,
Thanks for your quick reply. I am unable to unpivot those fields like the image below, i get an error when i try to apply changes saying :
But this is not the main problem, I have tried trimming and cleaning the columns, even after unpivoting in the query editor, I get errors while coverting to numbers.
When i try to change data type in pbi desktop, it asks me this and i get erros if i click yes.
Anonymous Remove any relationships to that table. Unpivot. Create a bridge table to bridge that table to the other table that was related to it. Did the clean and trim allow you to convert it to a number?