How to calculate percentage in Power Pivot

Occasional Contributor

How calculate  percentage of  i.e. Total Rs.6600*500% in Power Pivot.

formula is given below and also excel sheet is attached for ready reference.  

500% percentage of increase:=[Total]*500


Yours cooperation will be highly appreciated.




1 Reply

@Jalil1985 Looked at your "data model" and don't really understand what you want to do. But, a a general note, 500% = 5, so you should multiply the whatever base number you have by 5, not by 500.