Get the total average percent change of values on Matrix Visual

[bsg009]

Hi,

Just come across with this roadblock where I can't find the right dax code to get the total average percent change of the pricing. Could someone help create the dax based on this table? Thanks!

[Anonymous]

Hi @bsg009 ,

If I understand correctly, the issue is that you want to calculate the total average percent change of price.

Try to enter the following DAX formula to calculate.

AveragePercent = 
AVERAGEX(
    Sales,
    DIVIDE(
        (Sales[CurrentPrice] - Sales[PreviousPrice]),
        Sales[PreviousPrice],
        BLANK()
    )
) * 100

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format to make a deep troubleshooting? It would be helpful to find out the solution.

Best Regards,

Wisdom Wu

[Ritaf1983]

Hi @bsg009 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly