Forum Discussion
Create costum column with IF statement based on Data source
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!
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.
2 Replies
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!
