Sameperiodlastyear YTD not working as intended

[lstenz]

Hey,

I am tasked with creating a YTD value and a value that shows the percentage change from last year's data of the same timeframe.

So I created 3 measures:

YTD: 

CALCULATE(sum('KPIs_GoogleSearchConsole'[Organic Impressions]),filter(ALL('LU_DATES'),'LU_DATES'[Year]=max('LU_DATES'[Year])))

LYTD: 

CALCULATE(sum('KPIs_GoogleSearchConsole'[Organic Impressions]),SAMEPERIODLASTYEAR(LU_DATES[Date]))

DELTA: 

DIVIDE( [GSCOrgImprThisYear] , [GSCOrgImprLastYear]) - 1

I created a table to see if it works and as far as I understand, the LYTD should show me data next to the 2 million from jan 23, right? This also means that the delta doesn't work as I want it to and I've spent about 6 hours over the past two days, trying to figure this out and searching for a solution. (Just started working with PowerBi)

Please help

Leo

[vanessafvg · Accepted solution]

can you provide some sample data in text form 

for this measure

CALCULATE(sum('KPIs_GoogleSearchConsole'[Organic Impressions]),filter(ALL('LU_DATES'),'LU_DATES'[Year]=max('LU_DATES'[Year])))

is there a reason you aren't using the YTD functions in power bi?

so providing some sample data with an example of what you are expecting will help solve the issue.

thanks

[lstenz]

I can't believe it but after actually using the totalytd function instead of what I previously used, it actually works now. I got the initial formula from a tutorial and since the value was right, I just went along with it and thought the problem was with the sply function. 

Thank you so much for helping me with this!