Same period last year calculated column based on a condition

[tomislav_mi]

Hey guys,

I am struggling with how to get one challenging calculated column. I appreciate every help I can get.

This is my data set and the desired calculated column is in orange.

So, I am trying to compare Ending MRR of every customer and it's Ending MRR in the same period last year, and if the previous year Ending MRR is blank, I would need to get current Ending MRR.

Basically, I want to test is there any customer who was not active last year and is active now.

Customer	Report Date	Ending MRR	Same period last year MRR
A	2/28/2019	236
A	3/31/2019	236
A	4/30/2019	236
A	12/31/2019
B	6/30/2018
B	7/31/2018
B	8/31/2018
B	9/30/2018
B	10/31/2018
B	11/30/2018
B	12/31/2018
B	1/31/2019
B	2/28/2019
B	3/31/2019
B	4/30/2019
B	5/31/2019
B	6/30/2019
B	7/31/2019
B	8/31/2019	316	316
B	9/30/2019	316	316
B	10/31/2019	316	316
B	11/30/2019	316	316
B	12/31/2019	316	316
B	1/31/2020	316	316
B	2/29/2020	316	316

Any help is welcome.

Thanks!

[Greg_Deckler]

So you normally need a separate date table for time intelligence functions like SAMEPERIODLASTYEAR. https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...