Forum Discussion

jtemes's avatar
jtemes
Icon for Helper I rankHelper 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...
Need Help
  • amitchandak's avatar
    amitchandak
    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))

jtemes's avatar
jtemes
Icon for Helper I rankHelper I
4 years ago

The issue is that the table has more columns with other data and, if I do that, these data would be inaccurate.