Forum Discussion

mollig3's avatar
mollig3
Frequent Visitor
7 years ago
Solved

Insert Percentage column based on Month Number

Hello, I have a table that looks like the one attached. I want to add an additional column that will spit out a number for the total time divided by the total for that month. For example in the first row, I would want the new column to be 7089/65075 (sum of all total times for month number 1). Thank you!

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi mollig3 

     

    Is what you show a table or a table visual? Do you want a calculated column or a measure?

    Are the fields Total_time_c and Job Type measures? Are they summarizations of the fields or just the plain values? You'd need to give more details.

     

    If it is what I think it is, you can create a measure like:

     

     

    Measure =
DIVIDE (
    SUM ( Table1[Total_time_c] ),
    CALCULATE (
        SUM ( Table1[Total_time_c] ),
        ALLEXCEPT ( Table, Table1[MonthNrR.] )
    )
)

     

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi mollig3 

     

    Is what you show a table or a table visual? Do you want a calculated column or a measure?

    Are the fields Total_time_c and Job Type measures? Are they summarizations of the fields or just the plain values? You'd need to give more details.

     

    If it is what I think it is, you can create a measure like:

     

     

    Measure =
DIVIDE (
    SUM ( Table1[Total_time_c] ),
    CALCULATE (
        SUM ( Table1[Total_time_c] ),
        ALLEXCEPT ( Table, Table1[MonthNrR.] )
    )
)