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.
Hello, i'm appending two tables with two columns: One is projects and the other is actuals.. The issus is that actual come in idfferent formats. In table one is regularnumber let's say: 100.000 € the other is in 100 K €. Is there any way I can homogenize both formats without changing sourcing tables?
Thanks in advance.
Solved! Go to Solution.
Hi @i4696,
The best way is to do it in the query editor, maknig the formatting change creating a new column and then deleting the previous one. The query editor is like a macro and every single time you update your data the steps are run and your information is prepared as your need, and you don't need to make the changes on the original data.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @i4696,
The best way is to do it in the query editor, maknig the formatting change creating a new column and then deleting the previous one. The query editor is like a macro and every single time you update your data the steps are run and your information is prepared as your need, and you don't need to make the changes on the original data.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |