Forum Discussion
Solved
Most Current cell value ignoring blanks
I am trying to make a dashboard from an excel document that gets pulled in from our internal sharepoint that my staff keep up to date. My dashboard should show the current total of workstations on t...
thebigbamf , Try a measure like, assuming [Total Workstation Objects] is a column
LatestTotalWorkstations = LASTNONBLANKValue(AD[Date], Sum(AD[Total Workstation Objects]) )
Power bi tutorial: DAX functions: lastnonblankvalue , firstnonblankvalue: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=26940s
Hi, thebigbamf
You can try the following methods.
Measure =
Var _maxdate=CALCULATE(MAX(AD[Date]),FILTER(ALL(AD),[Total Workstation Objects]<>BLANK()))
Return
CALCULATE(MAX(AD[Total Workstation Objects]),FILTER(ALL(AD),[Date]=_maxdate))
Is this the result you expect? Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.