cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

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%

1 ACCEPTED SOLUTION

Accepted Solutions

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

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.

12 REPLIES 12

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

Screen Shot 02-14-19 at 04.29 PM.PNGScreen Shot 02-14-19 at 04.30 PM 001.PNGScreen Shot 02-14-19 at 04.31 PM.PNG

Highlighted
vineet-nair Frequent Visitor
Frequent Visitor

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

You can create a new column in the table that needs the new value and use a similar formula like below. Let me know if it worked!

 

Award = MINX(FILTER(Awards,Awards[initial] <= Sales[Revenue] && Awards[final] >= Sales[Revenue]),Awards[%award])
 
ans.png

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

I will try this now, will let u know if I got it Smiley Wink thank you.

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

Can I do this in the power bi service or only the desktop? Not sure if I can create a pbix file in desktop and connect to my excel file in sharepoint.

vineet-nair Frequent Visitor
Frequent Visitor

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

You should be able to do it in either of them. For Desktop, refer this thread: https://community.powerbi.com/t5/Desktop/Import-Data-from-an-Excel-sheet-in-SharePoint/td-p/47223

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

Hmm, Can't find the option to create another column in the web service. Are u sure about that? I already tried several times, Maybe is better to create everything in the desktop, but I will only be ble to do that tomorrow.

vineet-nair Frequent Visitor
Frequent Visitor

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

Yes, try desktop. Power BI service doesn't support creating columns/measures or changing the data model.

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

I see that I can't download the pbix file that I've already made, will need start everything from the zero.

Will check if I can send the pbix file on desktop (who is connected with a sharepoint excel file) to the service.... Not sure if this is gonna work.

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

So, I have created a .pbix file, I tried to create the connection using the option "Sharepoing Folder", however, I've received an strange error regarding my data inside the file (Which prob is a bug, because in the PowerBI service it worked perfectly). In face of this, I've created sharepoints lists from my tables that are inside my excel file.

I already loaded the data and uploaded the pbix file to my service. The problem is even if I config my credentials properly, my report DON'T LOAD the data that I change in my excel file. It should be working, right?