Search found 3 matches

by misqadv
Fri Feb 23, 2018 6:54 pm
Forum: PowerPivot/DAX
Topic: Lookup formula from excel to dax
Replies: 1
Views: 492

Lookup formula from excel to dax

Hi guys, Im trying to do calculation from Excel in PowerPivot but I have problem (of course) with vlookup function. The formula that I'm trying to change for DAX is below: =IFERROR(IF(VLOOKUP(E2;Sheet1!$H$2:$H$15;1;)=E2;G2-I2;);H2-I2). I already created another data source in PowerPivot but I cant m...
by misqadv
Wed Jan 10, 2018 6:01 pm
Forum: PowerPivot/DAX
Topic: Show top 3 and group rest values.
Replies: 2
Views: 633

Re: Show top 3 and group rest values.

Hi,

Im using Excel 2016. I've added attachment with workaround that I currently using, All of this is need to creat one chart. In all of my other reports I've already implemented PowerPivot.

Thank you all for your help.

BR,
Michał
by misqadv
Wed Jan 10, 2018 12:34 am
Forum: PowerPivot/DAX
Topic: Show top 3 and group rest values.
Replies: 2
Views: 633

Show top 3 and group rest values.

Hi, Im looking for the way to show in pivot table top3 max values (i.e. top 3 countries with biggest revenue) and group other countries in one cell. This thing will be used in monthly reports, so it will be good to make it atomatic. Is it possiable? I will be very grateful for all your help. BR, Mic...

Go to advanced search