Forum Discussion

Helper I

7 months ago

Calculating YOY Change for Measure

I am having trouble calculating YOY change for select measures Conv Rate ROAS CPM Eng Rate Email CTOR Thanks for any help you can provide! Recap Summary.pbix

Community Support

6 months ago

Hi jmorela1

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

Helper I

6 months ago

The issue is not resolved

v-karpurapud
Community Support
6 months ago
Hi jmorela1

From the dataset provided, April 2022 ROAS is calculated as 0 because Revenue is 0 and Spend is greater than 0. Since the YOY percentage uses (Current − Prior) ÷ Prior, having a prior value of 0 makes the calculation undefined, so Power BI returns BLANK. This is normal for ratio-based metrics and is not a product issue. If a percentage needs to be shown with a zero baseline, an adjusted calculation would be necessary instead of a standard YOY measure.

Regards,

Microsoft Fabric Community Support.
- v-karpurapud
  Community Support
  6 months ago
  Hi jmorela1
  
  Based on the dataset reviewed, the behavior aligns with standard DAX rules. Since the prior-period ROAS evaluates to 0, the YOY calculation is undefined and Power BI correctly returns BLANK. This is normal behavior, not a product issue.
  
  If you’re seeing different results in your full model, I recommend posting in the Power BI Community for further validation or engaging a Power BI partner for hands-on support:
  https://www.microsoft.com/en-us/power-platform/products/power-bi/partners#
  
  Regards,
  
  Microsoft Fabric Community Support.