Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have this pbix file https://drive.google.com/file/d/1cXmhlrhnx3FLgIkx03hypBDaETE-pPFd/view?usp=sharing
I have formatted the data in sheet 1 as whole number and the data in sheet 2 as text. When I click on transform data, both columns have "123" indicating that both are numbers. Why is this so?
Is there a way to go to Changed Type and copy the contents from the formula bar for one table and paste it to another table. This is useful when I have to change the data type for multiple columns and don't want to repeat the process.
Thanks.
Hi @prothinker ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Stephen Tao
Hi @prothinker ,
For the idea you put forward, there is no such function that can be realized at present. You can submit your idea and vote on this website.
There is a function to automatically detect the data type, hopefully it can reduce your unnecessary operations.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @prothinker ,
Once you have changed the type of both the columns in editor, it will be remain same until you change it.
Please find my pbix file here pbix file
And yes, you can change the type of more columns in one ago by specifying in formula bar with columnname and their type, like below with the braces.
= Table.TransformColumnTypes(#"Added Index",{{"Column 1", type text}, {"Column 2", type text}})
HI @prothinker
It is the same column from same table, which can be of only one type. either number or text.
What ever type you selected at the end will be reflected on both the sheets.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi
Thanks for your reply.
The column names are the same but they are from two different tables one in Sheet 1 and the other in Sheet 2.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |