Forum Discussion
Solved
Data is Blank
Hi!
I am trying to pull a table that gives me last fiscal year unit qty. i tried doing this through date add, etc but it was not pulling by the fiscal year, only the actual year.
below is what i am trying to use
LY Invoiced =
CALCULATE(SUMX('Past Order', 'Past Order'[Qty]),
FILTER('Past Order', 'Past Order'[Fiscal Year] = [Curr Fiscal Year]-1))
Any ideas on how to make this come back with information? its currently coming in blank
I just figured it out! This ended up working. 🙂
LY Invoiced =CALCULATE(SUM('Past Order'[Qty]),FILTER('Past Order', 'Past Order'[Fiscal Year] = CALCULATE(MAX(Dates[Fiscal Year]),FILTER(Dates,Dates[Date] = TODAY()))-1))
2 Replies
I just figured it out! This ended up working. 🙂
LY Invoiced =CALCULATE(SUM('Past Order'[Qty]),FILTER('Past Order', 'Past Order'[Fiscal Year] = CALCULATE(MAX(Dates[Fiscal Year]),FILTER(Dates,Dates[Date] = TODAY()))-1))
