Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate multiple columns

Hello Experts,   I am new to DAX queries. I am trying to calculate following fields, but unable to do so.   Column A Column B Column C Column D 85 39 30 21   my goal is to calcul...
Help Requested
Help required
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello Ankit,

     

    Thanks for your response. I was able to derive accrurate figure based on the script mentioned below. Not sure why.

     

    Instead, i wrote below one and got the correct answer

     

    divide(Table[Column1] + Table[Column2] + Table[Column3], Table[Column4])

     

    regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Ankit,

 

Thanks for your response. I was able to derive accrurate figure based on the script mentioned below. Not sure why.

 

Instead, i wrote below one and got the correct answer

 

divide(Table[Column1] + Table[Column2] + Table[Column3], Table[Column4])

 

regards