Forum Discussion
undefined
Hi, I have 2 tables loaded in my PBI, both of which have the same columns but data is different. One set of data is filtered on the basis of 'Company' and other set of data is filtered on the bas...
Hello - there are a couple of options to solve this.
- You can use measures - create two measures which perform the calculation - one for each table, then create a third measure which adds the two measures together. It is this third measure which you will add to the visual.
- If the column names are the name but the rows have different data, in Power Query, you can add a new column to both tables to indicate the category, then append the two tables and load the data model - then your data will be displayed by category.
Aditi27 Can you please review the proposed solution and let me know if this answers your question? Thanks!