Solved: How can I get one value and give the of him betwee... - Page 2

brunozanoelo · ‎02-14-2019

Hi my friends,

I have one excel table in my sharepoint drive, the problem that I'm facing is that I have one value called "Receita Bruta" this value need to be used to find what line he fits in the other table, he need to be compared between the values in this other table to give the right percentage result.

There's any way that I can do this?

Please, see the attached images below. This example the result would be 45%

brunozanoelo · ‎02-20-2019

I solved my problem. I made one Column in excel checking what line is the one that I need to present in the dashboard.

IF(E(ResultadoInadimplencia[Inadimplência]>A2;ResultadoInadimplencia[Inadimplência]<B2);1;0)

1 is that is between the numbers.

0 is that is not between the numbers.

I used the PoweBI Service to build the Dashboard., NO SUCCESS with the Desktop and trust me, I tried SEVERAL TIMES AND SEVERAL OPTIONS. Microsoft should pay more attention on this, the Sharepoint option is useless in PBI Desktop at my experience so far.

View solution in original post

How can I get one value and give the of him between the values of one table?

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024