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.
I'm using Datamart to write queries and I'm new. I have seven tables merged in different ways. I need to choose columns but want to do it the most efficient way possible in case I mess it up and have to do rework.
Should I choose columns in the original tables or in the merged tables? Which is most efficient and easiest to track back to?
Also, I need to merge two columns, but I want to keep the original two columns, a total of three columns. I know how to merge, but the original two columns were then gone. How do I keep all three?
Thanks!
Solved! Go to Solution.
@jamied Add a custom column like this:
=[Column1] & " " & [Column2]
@jamied Add a custom column like this:
=[Column1] & " " & [Column2]
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.