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 am working on a historical data report that revolves around 600 cost codes and applying time and location factors to adjust the costs to current market values (95% of the codes have values so I cannot shrink the tables). I have imported all of the data into 2 tables that are around 300 columns each, is there an easy way to apply the below equation to all of these columns without individually typing in the same equation 600 times?
Solved! Go to Solution.
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Thanks for the sugestion, I ended up changing how my data was formated and imported into PowerBI so I was able fix the issue.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |