Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

issue with snow schema when using SAMEPERIODLASTYEAR?

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?