Forum Discussion

kalpanaV's avatar
kalpanaV
Icon for Helper IV rankHelper IV
9 years ago

Do calculation on cell level

Hi Here, i want to display in the new column  for the first row (2/45)1*12 second row =( (2+3)/24)2*12 third row =((3+2+1)/30)/3*12 how to write dax.
Need Help
kalpanaV's avatar
kalpanaV
Icon for Helper IV rankHelper IV
9 years ago

hi 

Thanks 

 

but the thing is,  i have to take HC from other table which is having four months of data.

V column is the one which i have to take count having only V from another column in the same table.

 

hope, i explained clear now

tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

Hi kalpanaV,

 

I got your situation cause i'm used to work with HR data, for beginner, the simple way is you use "group by" (Summarize method or Addcolumns with Summarize method) to generate new table like your picture. Or you could let me observe your sample transaction data to have proper solution(cause i'm not sure that could achieve your requirement with one measure expression)