Calculated Column - Calculation to Sum based on Date

[Anonymous]

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/2018	410.00	39475.00
01/02/2018	505.00	89704.00
01/02/2018	458.00	122174.00
01/02/2018	818.00	23857.00
01/02/2018	410.00	80644.00
01/03/2018	525.00	36850.00
01/03/2018	458.00	27825.00
01/03/2018	718.00	134855.00
01/03/2018	410.00	25143.00
01/03/2018	525.00	19537.00
01/03/2018	967.00	113036.00
01/03/2018	1369.00	72727.00
01/04/2018	1138.00	88718.00
01/04/2018	1325.00	148039.00
01/04/2018	926.00	25400.00
01/04/2018	162.00	141660.00
01/04/2018	125.00	56406.00
01/04/2018	530.00	33250.00

[Fowmy · Accepted solution]

@Anonymous 

Please try this New Column: 

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

[Fowmy · Accepted solution]

@Anonymous 

Please try this New Column: 

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

[Anonymous · Accepted solution]

many thanks