Data is Blank

[ebrownretail]

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

[v-yohua-msft]

Hi, @ebrownretail 

Glad to hear you solved the problem yourself!

Best Regards

Yongkang Hua

[ebrownretail · Accepted solution]

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