Forum Discussion

Frequent Visitor

5 years ago

Solved

SAMEPERIODLASTYEAR WITH EXCLUSIONS

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

Greg_Deckler
5 years ago
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-TITHW/m-p/434008

4 Replies

Pigbag1962
Frequent Visitor
5 years ago
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
  Community Champion
  5 years ago
  Pigbag1962 Eh, happens to everyone!!
Greg_Deckler
Community Champion
5 years ago
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-TITHW/m-p/434008
- Pigbag1962
  Frequent Visitor
  5 years ago
  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