SAMEPERIODLASTYEAR WITH EXCLUSIONS

[Pigbag1962]

Hi I have the measure below and want to then have the same measure but for the same period last year.

QTY YTD Ex Stud = CALCULATE(TOTALYTD([QTY Total],'Rolling Livestock Data'[Create dte]),'Rolling Livestock Data'[Sale Parameter]<>"ST-PVT")

I have tried the following but it doesn't work and just retuens the same value as without the exclusion of the "ST-PVT".

QTY YTD LY Ex Stud = CALCULATE([QTY YTD],SAMEPERIODLASTYEAR('Date Table'[Date]),'Rolling Livestock Data'[Sale Parameter]<>"ST-PVT")

Can someone explain where I am going wrong?

Cheers

Damon

[Pigbag1962]

OMG! know your data! After struggling with this I went back to my data and the reson for no change ws that there were no items to be excluded!

It is always something simple.

Thanks for Greg though for his time.

[Greg_Deckler]

@Pigbag1962 Eh, happens to everyone!!

[Greg_Deckler · Accepted solution]

@Pigbag1962 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, 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...

[Pigbag1962]

Thanks for your response Greg. There is some stuff to work throught there! Unfortunately it is all a bit beyobd me at the moment, but hopefully I will get a handle on it at some point.

Damon