Forum Discussion

ganchevd's avatar
ganchevd
Icon for Helper I rankHelper I
7 years ago
Solved

Calculate the difference from the MAX value in a column

Hi,   I have an issue with the MAX value formulas in Power BI. I use it quite simple in Excel but it is different in Power BI. So the Excel formula I use looks like: =C2/MAX($C$2:$C$27). which I us...
Need Help
Tips and Tricks
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    ganchevd Here it is..

     

    Ranking = TestMax[RevAnnual]/MAX(TestMax[RevAnnual])

     

  • Fcoatis's avatar
    Fcoatis
    7 years ago

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi ganchevd,

 

Have you solved your problem?

 

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

 

If you still need help, please share your desired output so that we could help further on it.

 

Best Regards,

Cherry

ganchevd's avatar
ganchevd
Icon for Helper I rankHelper I
7 years ago

Well the desired output is what PattemManohar showed and Fcoatis in his fist proposal of a solution. Still it is far more complicated since I use direct link to the SQL database of MS DynamicsNAV and I have the information from three tables which i use to obtain the sample above. This was misleading to everyone who tried to help.

 

So. I have a table of Sales. There I have approximately 1m postings. I have a table Customer, which is linked to the Sales table by the uniqe CustomerNo. I have a third table which is the Differed Rev. And I made a measure to subtract from the differed rev from the sales, so that I'd be able to have a clear view over the revenue. In the visual table I'd shared I used as follows: Customer Name column from table customers and the RevAnnual measure. I am still not able to calculate the deviation of each customer revenue compared to the customer with the MAX revenue. It is easy in Excel but I'd like to be able to abandone these exports and justification of the data from NAv to Excel and make it life.