My Last Year Measure is not working for 2022

[FPP]

Hi, I have following Measures:

E Count =

VAR CountD =
CALCULATE (
COUNTROWS (
FILTER (
SUMMARIZE (
FILTER ('Losses', 'Losses'[Status] = "closed")
, 'Losses'[CK], "ExpenseSum", SUM ('Losses'[Expense])
),
[ExpenseSum] <> 0
)
),
USERELATIONSHIP ('Calendar'[Date], 'Losses'[ECD])
)

RETURN
CountD

E Count LY =

CALCULATE (

[E Count],

SAMEPERIODLASTYEAR ('Calendar'[Date])

)

I have table visual with a filter of iSYTD set to TRUE.  This limits the table to only include values in older years where this year has the same dates.  In other words: Only include Jan 1,2019-Jan24, 2019 when adding up 2019.
All of the values are correct except the last year.
Example:

Year	E Count	E Count LY
2019	604
2020	716	604
2021	783	716
2022	845	1182

How do I fix E Count LY for my last year (2022)?

[v-yalanwu-msft]

Hi, @FPP ;

So your problem has been solved?

 If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

If not, could you share a simple after removing the sensition  information?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FPP]

I now have a file.  How do I upload it?

[amitchandak]

@FPP , Make sure Calendar table is marked as date Table and Year is coming from Calendar.

also try

E Count LY =
CALCULATE (
[E Count],
dateadd('Calendar'[Date], -1, year)
)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...

[FPP]

I am trying to build a pbix with fake data.  I am having trouble replicating the issue.  I will keep working on it.

[FPP]

My Calendar table is marked as a date table.  I tried your DAX, there were no changes.

[amitchandak]

@FPP ,
Can you share  a sample pbix after removing sensitive data.

[FPP]

Try this link:
https://goremutual-my.sharepoint.com/:u:/g/personal/fpimentel_goremutual_ca/ET7LXN0ZsXpMgivwLxUXXVMB...