Forum Discussion
Helper IVDo calculation on cell level
Memorable MemberHi kalpanaV,
Your fomular is not clear. but you could create calculated column:
% attr = var currentIndex= Data[Index] var currentHC= Data[HC] var total = CALCULATE(SUM(Data[V]),FILTER(Data,Data[Index]<=currentIndex)) return 12* DIVIDE(total,Data[HC]*currentIndex)
Helper IVhi
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
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)
It would help if you would include your model and desired results.
- kalpanaV
Sure, I will give the headers since the data is confidential.
AttritionCapacity
Two tables called Attrition and Capacity
In the attrition table , column "Resignation type"..its having info about Voluntary(V) or Involuntary(NV).
In the capacity table, four months of data is there. i grouped by month wise
so finally it will be having two columns called count(HC), Month.
Output
Hope , you got it. what i want.
- tringuyenminh92
Hi kalpanaV,
In this case, you could use Anonymous (using calculated measure) or my solution (using calculated column), both of them will achieve the column V % (YTD attrition %) for you. For overall YTD, hope you provide its fomular and we could suggest more expression.