Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |