Forum Discussion
How to get Lastest forecast value
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
3 Replies
- Greg_Deckler
Community Champion
Anonymous - Try Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
- amitchandak
Super User
Anonymous , Try
lastnonblankvalue(Table[RptDate], max(Table[Value]))OR
calculate(lastnonblankvalue(Table[RptDate], max(Table[Value])), allexcept(Table[Attribute]))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
