Forum Discussion
Create a new table from existing one using slicer values
Hello everyone, I have a Table t with 3 columns - Name of the company, Financial item and Value of the financial item. Financial item represents the name of the certain item in financial report, l...
parry2k
Super User
Super UserAnonymous it will be easier to understand the problem if you provide sample data in table format and the expected output.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi parry2k ,
Here is sample table:
Name of the company Financial Item Value A Revenue from online sales 110.000,00 A Other revenue 10.000,00 A Cost of revenue 30.000,00 A Cost of employees 20.000,00 A Income before tax 70.000,00 A Interest income 5.000,00 A Tax 8.400,00 A Net income 61.600,00 B Revenue from online sales 105.000,00 B Other revenue 40.000,00 B Cost of revenue 20.000,00 B Cost of employees 10.000,00 B Income before tax 115.000,00 B Interest income 1.000,00 B Tax 13.800,00 B Net income 101.200,00 C Revenue from online sales 150.000,00 C Other revenue 5.000,00 C Cost of revenue 100.000,00 C Cost of employees 50.000,00 C Income before tax 5.000,00 C Interest income 1.000,00 C Tax 600,00 C Net income 4.400,00 D Revenue from online sales 10.000,00 D Other revenue 1.000,00 D Cost of revenue 6.000,00 D Cost of employees 6.000,00 D Income before tax -1.000,00 D Interest income 1.000,00 D Tax 0,00 D Net income -1.000,00 The user will choose financial Item and value range for that financial item. The output shold be the list of companies that meet those conditions. For example, user wants to see which companies have Revenue from online sales bigger than 100.000,00 and at the same time Tax lower than 10.000,00. In our example, only A and C companies meet those conditions so the output should look like this:
Name of the company A C
