issue with snow schema when using SAMEPERIODLASTYEAR?

[ovonel]

I have a schema with relationships:

Many Revenue[ClientKey] : 1 Client[ClientKey]

filter: << To Revenue

Many ClientType[ClientNo] : 1 Client[ClientNo]

Many ClientType[Year] : Many Date[Year]

Not sure how I will use the last 2 relationships in the pbix; but I set the filter to <<"Both tables">>

I am having issues with basic measures:

• Revenue := YTDCALCULATE([Revenue] ,DATESYTD('Date'[Date] ,"31/05" ))

• Revenue LYTD := CALCULATE( [Revenue YTD],SAMEPERIODLASTYEAR('Date'[Date] ) )

Revenue displays ok. But Revenue LYTD, displays only the total in a table visualization. Could the relationship somehow make this?

[v-eqin-msft]

Hi  @ovonel ,

Could you tell me if @sm_talha 's post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you‌‌

Best Regards,
Eyelyn Qin

[sm_talha · Accepted solution]

I believe the problem is with this relationship Many ClientType[Year] : Many Date[Year], you need to change the relationship to be based on the lowest granularity level i.e. Dates. Power BI time intelligence functions only works with continuous dates. 

If you have Dates column in ClientType table then add Dates column in the Date table and create a relationship based on that.