Forum Discussion
Creating New Table using values in other tables in PowerBI
I have 2 tables. Table1 has static data as below:
| KPI | Target |
| A | >90% within 30 Business Days |
| B | >90% within 60 Business Days |
| C | >90% within 30 Business Days |
| D | >90% within 60 Business Days |
| E | >90% within 30 Business Days |
| F | >90% within 60 Business Days |
Table 2 has all the columns, calculated measures. This is the main table. There are measures (count & SLA%) for each KPI values.I need to combine this 2 tables & the output should be as below, based on the matching KPI values:
| KPI | Target | SLA | Count |
| A | >90% within 30 Business Days | 91% | 11 |
| B | >90% within 60 Business Days | 100% | 1 |
| C | >90% within 30 Business Days | 100% | 7 |
| D | >90% within 60 Business Days | 21% | 19 |
| E | >90% within 30 Business Days | 100% | 3 |
| F | >90% within 60 Business Days | 100% | 1 |
Any help is appreciated!
4 Replies
I have posted the table 2 data . Any ideas is appreciated !
Hi moumitadeb , can you please sample data for table 2 ?
I have posted the table 2 data . Any ideas is appreciated !
