Forum Discussion
Function 'SAMEPERIODLASTYEAR' expects a contiguous selection Issue
Hi v-jiascu-msft,
I am using filter instead as follow:
TOTAL SALES YTD =
CALCULATE (
SUM (FACT[Sales] ),
FILTER (
ALL ( 'Date' ),
YEAR ( 'Date'[Date] ) = YEAR ( TODAY () )
&& 'Date'[Date] <= TODAY ()
)
)Thanks all for your help!
Your relationship diagram looks weird to me. I would expect a one-to-many relationship from your date table to your fact table, not a many-to-many relationship filtering the other way.
Hi AlexisOlson,
I try to create one-to-many relationship from my date table to my fact table but always get this message:
"The cardinality you selected is not valid for this relationship".
My date calendar is using this formula:
dates = DATEADD('Date'[Date],0,year)
Is it something else I can try?
Try deleting and recreating the relationship. The dates table should not have multiple rows for the same date.
If your dates table has duplicate dates, then something is likely wrong with it.
I deleted and re-created the link but same issue.
I also created a new date table : Date = CALENDAR(DATE(2016,1,1), today()), same issue with the relationship
In my date table, there is no duplication and I am using format Date.
Hi Anonymous,
The relationship could be the root cause. Can you change it to 1:* manually? Please also check if there are any duplicates. Please refer to the snapshot below.
The SAMEPERIODLASTYEAR works now after the release of the Composite model.
Best Regards,
Dale
