Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ，

Thank you for your kind reply!

Could you please explain how the value of 1820 in the 'Price Impact' column was derived? According to the logic and the data you provided, the calculation for price impact should be (Price CY - Price PY) * Units CY. Therefore, the price impact for Product A should be 1600 + 0 + 230 = 1830?

Did you not provide us with the complete table data? You calculated separately for YTD and MTD, but your data table only contains monthly data and does not have more complete data regarding dates!

Could you pleaseshare your Excel spreadsheet or your sample data file with us. Thank you for your understanding!

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best regards,

Lucy Chen

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

The below table shows price calculation performed on the monthly and YTD sales. I am only doing a simulation in excel as I am unable to share my company's data model.

 

Product ASalesCYUnitsCYPriceCYSalesPYUnitsPYPricePYPrice Impact
1500020025.00306018017.001,600
2462021022.00418019022.000
3575023025.00504021024.00230
YTD1537064024.021228058021.171,820
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.