dilawer5
Member
Dear Expert!
First of all thanks for your contribution in making things possible for learners.
I structured a set of tables and made relationships in power pivot to do following things
1. Make targets for orderbookers brand wise in currency value.
2. I want to make adjustments (calibration in their monthly targets) with ratio mentioned in table named as TGTCALIB.
Note: Targets are made from their previous sales history (which is available in two tables acutalsales1 and actualsales2) by multiplying and increased number let suppose 110% of sales history of last4months, I did it successfully. Butt, since every orderbooker has different circumstances , therefore, I need to calibrate their targets with different %age which is mentioned in TGTCALIB table.
Please share formula in DAX for two way lookup value so that i become able to multiply targets to ratios in TGTCALIB table.
First of all thanks for your contribution in making things possible for learners.
I structured a set of tables and made relationships in power pivot to do following things
1. Make targets for orderbookers brand wise in currency value.
2. I want to make adjustments (calibration in their monthly targets) with ratio mentioned in table named as TGTCALIB.
Note: Targets are made from their previous sales history (which is available in two tables acutalsales1 and actualsales2) by multiplying and increased number let suppose 110% of sales history of last4months, I did it successfully. Butt, since every orderbooker has different circumstances , therefore, I need to calibrate their targets with different %age which is mentioned in TGTCALIB table.
Please share formula in DAX for two way lookup value so that i become able to multiply targets to ratios in TGTCALIB table.