Measure Last year YTD with Sameperiodlastyear

[Anonymous]

Hello all,

Currently i want to create a new measure LYYTD for calculating the duration in our products.

LYYTD = CALCULATE([YTD];SAMEPERIODLASTYEAR('DATE'[DATE])

But the current issue is that i have a error which contains :

the current relationship between the table INCIDENT and DATE are:

What did i wrong?

Thank you!

R.

[v-sihou-msft]

@Anonymous

As the error messaged indicated, you must put a date column with "Contiguous" selection into SAMEPERIODLASTYEAR() function so that it can map the same date in last year. It means you need to put the contiguous dates in your visual, otherwise it will throw this error.

Regards,

[Phil_Seamark]

Hi @Anonymous

Have you tried setting the relationship direction back to single?

[Anonymous]

Hello,

Yes i just made into a  Single but still no result in the column DURATIONMINUTESYTD Please take a look in the following image.