How can I do one SELECT-FROM (USING WHERE) in one excel file?

[brunozanoelo]

Hi my friends,

I have some tables in my excel file, the main goal is to show to the company some general indicators of the departments and the goal number of them. So if the result (inserted manually) is between the values of the line, it will change one column with 0=not reached and 1=goal reached.

The problem that I'm facing is to show the total % of all the indicators.

How can I do one Select-from and using the 1 value as a filter?

In SQL would be:

Select percentage
from resultadosabertos
where meta=1

Check some ps pls.

This first ps is the current value of the indicator.

This second ps would be the table that I need to search for the value. The result would actually be 30%.

Thank you!

[v-juanli-msft]

Hi @brunozanoelo 

After importing the excel into Power bi desktop, you could create a visual to display the result by adding a filter as below:

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[brunozanoelo]

Hi @v-juanli-msft , I already did this, the problem is not actually this... =/

The problem that I'm actually facing is that I need to summarize all the results of the tables into one single field.

Example:
Table 1
30%

Table 2
20%

What I need: 50%
Why I need for: 50% / 2 = 25%

25% will be the final indicator, it summarize the result of each indicator and divide by the number of indicators. Can you help me with this?

Thank you anyway!

Best Regards
Bruno