Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Strategic Value

Hi everyone, I'm trying to calculate a strategic value, but I'm not sure how to do that in DAX. Below is logic and they come from one single table. Can you please help me have this in DAX? Stra...
DAX help needed
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hey, amitchandak thanks for your help. 
    I applied the below calculated column and it worked. 

    Planned Maintenance Strategic Value =
    var MAX_Value= MAX(Costs[Planned maintenance PV 30 years])
    var Min_Value = MIN(Costs[Planned maintenance PV 30 years])
    return 100-((Costs[Planned maintenance PV 30 years]-Min_Value)/(MAX_Value-Min_Value))*100
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous ,

 

M1 =

divide(

sum(Table[Planned maintenance]) -Min(Table[Planned maintenance]),

max(Table[Planned maintenance]) -Min(Table[Planned maintenance])

)

 

If needed

M2 = calculate([M1], all())

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey, amitchandak thanks for your help. 
I applied the below calculated column and it worked. 

Planned Maintenance Strategic Value =
var MAX_Value= MAX(Costs[Planned maintenance PV 30 years])
var Min_Value = MIN(Costs[Planned maintenance PV 30 years])
return 100-((Costs[Planned maintenance PV 30 years]-Min_Value)/(MAX_Value-Min_Value))*100