Forum Discussion
Addcolumn and vlookup
Hi Anonymous ,
I've assumed some data:
Facttable:_SlicerTable:
1.Using the dax expression you provided I created the calculated column ‘FY24_AOP_Rate’
2.Using the dax expression you provided I created the measure ‘_SumxAmount’, The function successfully computed the data I assumed.
Make sure the correct columns are applied in the lookupvalue function, there should be a many-to-one relationship between the fact sheet and the dimension sheet. If there are multiple rows of data that satisfy the filter criteria, the lookupvalue function will only return the first row of data that matches, which can make the result of the calculation wrong.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I've assumed some data:
Facttable:
_SlicerTable:
1.Using the dax expression you provided I created the calculated column ‘FY24_AOP_Rate’
2.Using the dax expression you provided I created the measure ‘_SumxAmount’, The function successfully computed the data I assumed.
Make sure the correct columns are applied in the lookupvalue function, there should be a many-to-one relationship between the fact sheet and the dimension sheet. If there are multiple rows of data that satisfy the filter criteria, the lookupvalue function will only return the first row of data that matches, which can make the result of the calculation wrong.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.