Forum Discussion

ckolahi's avatar
ckolahi
Frequent Visitor
4 years ago
Solved

Divide rows (calculated column) with different parameters

Hi Guys   I have the table below. The idea is to create a calculated column (in blue) to represent Actuals (A) vs Budget (B), for each month, quarter, product, reps etc..   Any ideas Thanks   ...
DAX
divide
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ckolahi

     

    Please try this code

    Desired =
    var maxamt=calculate(max(Feuil2[Value_SIP]),ALLEXCEPT(Feuil2,Feuil2[Names],Feuil2[Measure SIP],Feuil2[Month],Feuil2[Year]))
    return
    divide(Feuil2[Value_SIP],maxamt,0)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ckolahi

 

Please try this code

Desired =
var maxamt=calculate(max(Feuil2[Value_SIP]),ALLEXCEPT(Feuil2,Feuil2[Names],Feuil2[Measure SIP],Feuil2[Month],Feuil2[Year]))
return
divide(Feuil2[Value_SIP],maxamt,0)