How to get Lastest forecast value

[Anonymous]

Hi,Everyone

Need your help on how to get lastest value from lastest forecast version.I'm try to use calculate in sample below but it's show only max report date , 

please kindly advise 🙂Excepted valueCurrent

[amitchandak]

@Anonymous , Try

lastnonblankvalue(Table[RptDate], max(Table[Value]))

OR
calculate(lastnonblankvalue(Table[RptDate], max(Table[Value])), allexcept(Table[Attribute]))

[Anonymous]

Thanks amitchandak , I've try calculate+lastvaluenonblank ,it's work when no filter.

when i filter product or site , value is not changes , is there any solution to make it's dynamic ?

thank you very much in advance

[Greg_Deckler]

@Anonymous - Try Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434