Forum Discussion

alisonpappas's avatar
alisonpappas
Icon for Helper III rankHelper III
6 years ago

SAMEPERIODLASTYEAR function begins at wrong period

Hi All,   I am attempting to do a YOY change in power bi. When I use the SAMEPERIODLASTYEAR function, the returns are off.    Headers:  period, % esr, % esy sply, yoy change   As you c...
Help me
MartynRamsden's avatar
MartynRamsden
Icon for Solution Sage rankSolution Sage
6 years ago

Hi alisonpappas 

 

Is the Period column coming from a Date dimension table?

 

Also, please can you share your DAX expressions for the '% esr' and '% esr sply' measures?

 

Best regards,

Martyn