Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated Column - Calculation to Sum based on Date

Hi Experts   Need a calculated column calculation to sum based on dates ( i have sales for the same date) and then divide Amount by Rate values See sample Data   Month Amount Rate 01/02/...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Please try this New Column: 

    New Column = 
DIVIDE(
    Table3[Amount],
    CALCULATE(
        SUM(Table3[Amount]),
        ALLEXCEPT(Table3,Table3[Month] )
    )
)

     



  • Anonymous's avatar
    Anonymous
    5 years ago

    many thanks

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Please try this New Column: 

New Column = 
DIVIDE(
    Table3[Amount],
    CALCULATE(
        SUM(Table3[Amount]),
        ALLEXCEPT(Table3,Table3[Month] )
    )
)

 



  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    many thanks