Forum Discussion
Data conversion error
Anonymous , Open Power Query, Before the first change data type step, use clean and trim
Power Query Trim and Clean: https://youtu.be/NRYPsCnS0w4
If needed replacevalues
And they overwrite the datatype step and change datatype to decimal
Thank you it is solved.
Now when I try to do visuals I can not mutualize my data.
Indeed I have two data types in different tables :
- Power which is part of energy table
- Noise which is part of noise table
Therefore I want to mutualize both depending on the collected date but both tables have their own collected date and only one is being printed.
I have already tried to introduce cardinality and manage relationship but it did not work.
Hi Anonymous ,
The question is off topic, please consider creating a new thread to post this question.
If Amit's answer was helpful, please consider marking his answer as the solution, it will help more people find the answer quickly, thanks in advance!😊
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data