Forum Discussion

chrisjames10's avatar
chrisjames10
Regular Visitor
3 years ago
Solved

Making a calculated column with two values from different days by state

Hello!   I'm trying to figure out how to make a column in my table that displays the difference between the Allocated values (by state) from one day to the next. My table is updating daily with new...
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    chrisjames10 

    maybe you can try this

    column = 
var _last=maxx(FILTER('Table','Table'[state]=EARLIER('Table'[state])&&'Table'[date]=EARLIER('Table'[date])-1),'Table'[alllocated])
return 'Table'[alllocated]-_last

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

chrisjames10 

maybe you can try this

column = 
var _last=maxx(FILTER('Table','Table'[state]=EARLIER('Table'[state])&&'Table'[date]=EARLIER('Table'[date])-1),'Table'[alllocated])
return 'Table'[alllocated]-_last