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
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
Thank you this worked perfectly!
