Forum Discussion

Pigbag1962

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

Need Help

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

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

Forum Discussion

SAMEPERIODLASTYEAR WITH EXCLUSIONS

Related content

SAMEPERIODLASTYEAR()

Issue with SAMEPERIODLASTYEAR and Manual Time Intelligence

SAMEPERIODLASTYEAR is blank

Need Urgent Help on SamePeriodLastYear

Cumulative sum with exclusions