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
Ashish_Mathur
Super User
Super UserHi,
Create a Calendar Table and write this measure
Latest Total Workstations = CALCULATE(SUM(AD[Total Workstation Objects]),LASTNONBLANK('Calendar'[Date],CALCULATE(SUM(AD[Total Workstation Objects]))))