Forum Discussion

hxnwx's avatar
hxnwx
Frequent Visitor
4 years ago
Solved

Divide columns for percentage

Taking a break from banging my head.   I have a table sorted by date.  For each daily there are 3 columns, 1, 2, and 3 and a column for total.  I want to show a column for the percentage 1 is of to...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    hxnwx 

    You can add measures as follows:
    Modify and repeat for other two columns 

    Pcnt 1 = DIVIDE ( MAX( TableName[1] ) , MAX( TableName[2] ) )



     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

hxnwx 

You can add measures as follows:
Modify and repeat for other two columns 

Pcnt 1 = DIVIDE ( MAX( TableName[1] ) , MAX( TableName[2] ) )



 

mluanacruz's avatar
mluanacruz
Icon for Helper I rankHelper I
4 years ago

Hi Fowmy ,

But if you have 39 columns like mine. How to divide column 1/column 0, column 2 /columns 1 ... and so on...

 

 

Thanks for the help.

Michelle