Forum Discussion
Need help with price effect calculation
Hi, I tried using both calculated column and measure to calculate price impact but it is not returning my desired results. My goal is to create a visualization with a slicer which would show price i...
Hi Anonymous ,
Thank you for your kind reply!
Could you please provide a screenshot of this if it is in excel?
Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please check.
We recommend you to use the code.
PriceImpact = SUMX('Table', ([Price CY] - 'Table'[Price PY]) * [Units CY])Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.