Why the YOY Change isn't based on Sales YTD and Sales LYD

[newrice]

Hello,

The value isn't based on Sales YTD(222.86M), Sales LYTD(271.17M) when I use below measure.

YoY Change = DIVIDE([Sales YTD] - [Sales LYTD], [Sales LYTD])

I got 0.56(56%) rather than -0.178(-17.8%).

Hope someone could help me on this.

Thank you in advance,

[v-yiruan-msft]

Hi @newrice ,

If I understand correctly, the expected result for [YoY Change] is -0.178(-17.8%), but it return 0.56(56%). Could you please provide some raw data in your tables (exclude sensitive data) with Text format, the formula of measure [Sales YTD] &[Sales LYTD] and your visuals settings? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards