I have a formula,
FinalValue = (A/B)*C = (Total sales in last 6 months/no. of transactions in 6 months)* no. of customers with zero sales.
A=total sales in last 6 months
B=no. of transactions in 6 months
C=no. of customers with zero sales.
I can do it in DAX but there are issues. Now, I need to do this in a calculated table.
My main table called 'MergeTable' has customer, item, channel, year, month, sales.
A and B are calcualted at Item level ignoring the Customer
C is calculated at lowest granularity i.e. Customer level.
Please help me create a calculated table which can show A, B values for each row at Item level and C values at customer level.
