I would add a Year column to your table:
Year = YEAR([Date])
Then in your LY calculation, create this variable:
VAR __year = MAX([Year])
And then in your SUMX just FILTER yoru table to [Year]=__year - 1
Proud to be a Datanaut!
I had managed to achieve the outcome i was looking for in Power BI through going back to the Drawing Board.
All my issues were resolved once i imported at a Transaction ID level, instead of my lowest level being Barcode, which is essentially Product ID.
I can explain in more detail, but that would be pointless now. With that said, thank you for all your input
Dear @LazI happen to be facing a similar issue as you (SUMX formula on a time intelligence function), and wouldl be interested if you could share the details of the solution.
Thanks in advance!
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.