Forum Discussion
How to return the value only of table cell data
Hello World, I am working on creating an inventory visual that shows the levels of stock in our warehouse. The issue I am facing is the data adds multiple dates then returns the value. Exampl...
So you want the latest number of units? Then you'll likely want a measure similar to this:
Units = VAR _MaxDate = MAX ( Table1[Date] ) RETURN CALCULATE ( SUM ( Table1[Units] ), Table1[Date] = _MaxDate )
AlexisOlson
Super User
Super UserSo you want the latest number of units? Then you'll likely want a measure similar to this:
Units =
VAR _MaxDate = MAX ( Table1[Date] )
RETURN
CALCULATE ( SUM ( Table1[Units] ), Table1[Date] = _MaxDate )