Forum Discussion
Pigbag1962
5 years agoFrequent Visitor
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...
- 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
5 years agoFrequent Visitor
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_Deckler5 years ago
Community Champion
Pigbag1962 Eh, happens to everyone!!