Calculate dolar value from the last FY

[Anonymous]

Guys,

I have 2 table that don't connect directly each other.

When I try this fórmula the result is the current dolar.

calculate(MAX(d_USDratecountry[Value]),DATESBETWEEN(d_NTT_Dinamic_DataTable[Date],min(d_USDratecountry[StartDate]),MAx(d_USDratecountry[NextStartDate])))

I need the dolar from the past FY. I have already used "SAMEPERIODLASTYEAR", "ISAFTER", etc, but no one brings me the result that I'm looking for. Could give a hand for me?

Many thanks.

[Anonymous · Accepted solution]

I got it... kkk.

Last FY Closed = calculate(MAX(d_USDratecountry[Value]),previousyear(d_NTT_Dinamic_DataTable[Date]))

So, simple. Sometimes, you need break the focus to be open to new ideas.

I hope that can help someone with the same difficult.

Bye.