Forum Discussion

jtemes's avatar
jtemes
Helper I
4 years ago
Solved

Latest Available Data

Hi all I have gone through several threads trying to find what I want but I did not get a solution for my case (sorry if the solution has already been given to someone else). I have a table like th...
  • amitchandak's avatar
    4 years ago

    jtemes , try a measure like this with date table

    calculate(sumx(filter(Table, Table[End Date] <= Max('Date'[Date])), Table[Value]), crossfilter(Table, Date, none))