Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙂
@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
@Anonymous - Try Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |