query string
1 Topic
Quick Measure: Incorrect YOY calculation - handling negatives
Hello, YOY quick measure in Power BI results incorrect calculation when previous year data is negative or vice versa. Following quick measure formula results a negative 217% YOY where previous year value is minus 463 and current year value is plus 541. YTD_Total Sales Gross YoY% = VAR __PREV_YEAR = CALCULATE( SUM('Append1'[YTD_Total Sales Gross]), DATEADD('Date_Key'[Date], -1, YEAR) ) RETURN DIVIDE(SUM('Append1'[YTD_Total Sales Gross]) - __PREV_YEAR, __PREV_YEAR) Is there a way to edit the quick measure to add ABS? I'd prefer not create seperate measures for each metric we are tracking and calculate the YOY for each. It will be a very tedious workaround. Thanks, PetekSolved3.3KViews0likes4Comments