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.
Hey,
I'm using Azure Cost Management Connector in PowerBI and I would like to combine two tables together. I already did this via the Append query and it works fine, but I would like to add a custom column to the final Table which contains the information from which Table the data intially comes from.
Setup looks like the following.
1. Table contains Actual Cost
2. Table contains Amortized Cost
In both tables there is no information about, that it's actual or amortized cost. The only difference is in the PowerQuery where it looks like this:
The first table has "Key="usagedetails"" and the second table has "Key="usagedetailsamortized"". I would like to add this information about actual or amortized cost to a custom column so I can filter later for the Reports.
Any suggestion how this would be possible?
Thanks in advance!
Solved! Go to Solution.
In power query on the individual table queries (the ones that feed into the combine query) you could add a custom column of 'Cost Type' and set it to Actual or Amortized. Then that column will be included when you append them together.
In power query on the individual table queries (the ones that feed into the combine query) you could add a custom column of 'Cost Type' and set it to Actual or Amortized. Then that column will be included when you append them together.
Worked, thanks for the hint!
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |