Forum Discussion
How to calculate percentage in Power Pivot
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.
Regards
Jalil
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.
