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 data so ideally the column reflects the difference between the total allocated from that state on the current day and the total allocated from that state on the previous day. 

 

Thanks!! 

 

 

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

2 Replies