YoY% difference

[hkeeeen]

Hello community, I am trying to calculate the year to year difference between these two columns. The values are coming from one column and the year is not in date format, so a time intelligence function will not work.

[SamWiseOwl · Accepted solution]

Hi @hkeeeen 
Have you tried using Visual Level Calculations:
https://www.wiseowl.co.uk/blog/s3172/visual-calculations-pbi.htm

% previous = ([Sum of Price] - PREVIOUS([Sum of Price],1,COLUMNS)) /  PREVIOUS([Sum of Price],1,COLUMNS)

Otherwise you will need to create a measure like:
% change =

var y = selectedValue(table[year column])
Return

Divide(Sum(table[column]) -

Calculate( Sum(table[column]), table[year column] = y -1),

Calculate( Sum(table[column]), table[year column] = y -1)

)

[Anonymous · Accepted solution]

Hi ,

The method SamWiseOwl provided should be helpful. Besides, you can also try the following DAX formula.

Yeartoyear difference = 
var _year = SELECTEDVALUE('Table'[Year])
VAR _PreviousDate = CALCULATE (MAX('Table'[Year]), 'Table'[Year] < _year)
var _cost = SUM('Table'[Cost])
var _previouscost = CALCULATE(SUM('Table'[Cost]), 'Table'[Year] = _PreviousDate)
RETURN
   _cost - _previouscost

You can view the following links to learn more information.

Solved: Calculate difference between columns in matrix vis... - Microsoft Fabric Community

Solved: Calculate % difference between two years - Microsoft Fabric Community

Best Regards,

Wisdom Wu

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

[SamWiseOwl · Accepted solution]

Hi @hkeeeen 
Have you tried using Visual Level Calculations:
https://www.wiseowl.co.uk/blog/s3172/visual-calculations-pbi.htm

% previous = ([Sum of Price] - PREVIOUS([Sum of Price],1,COLUMNS)) /  PREVIOUS([Sum of Price],1,COLUMNS)

Otherwise you will need to create a measure like:
% change =

var y = selectedValue(table[year column])
Return

Divide(Sum(table[column]) -

Calculate( Sum(table[column]), table[year column] = y -1),

Calculate( Sum(table[column]), table[year column] = y -1)

)