Forum Discussion
Filters DAX sameperiodlast year issue
morning all believe it or not, i did not find the solution here...:) i have a Clustered Column chart with values forlast 6 months , based on "SignatureDate". to get these values, I use a filter on ...
DavidM06 Here are the two suggestions for your problem.
Suggestion 1: Remove .[Date] from SAMEPERDIODLASTYEAR and keep like this
LY = CALCULATE(SUM(Haraka[TCV]),SAMEPERIODLASTYEAR(CRM[DateSignature]))
Suggestion 2: Create a separate calender table and use this in SAMEPERIODLASTYEAR.
Calendar Table = CALENDAR(MIN(DateSignature),MAX(DateSignature))
Then connect this Date to CRM table's DateSignature using 1-many relationship and then create a below measure:
LY = CALCULATE(SUM(Haraka[TCV]),SAMEPERIODLASTYEAR(Calendar[Date]))