Forum Discussion

sohailstsindia's avatar
sohailstsindia
Helper I
8 years ago

Replace Value

  I need help to calclulate End of Service Benifit, for End of Service Benifit = (Basic*12/365)*21/12 =696.16  
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi sohailstsindia,

 

I notice that there are multiple records for "Basic", which one you want to refer to when calculating result for "End of Service Benifit"? Do you want to replace value in original column or generate a new custom column that has new results? Do you want to achieve this with Power Query or DAX?

 

Regards,

Yuliana Gu