Forum Discussion

JSR's avatar
JSR
Icon for Helper II rankHelper II
6 years ago
Solved

Get data from Filtered rows

Hi, A bit lost on how best get data from specific rows so looking for any advice, thanks.   Having a table like below.   I would like to get specific filtered rows and display its info int...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi JSR ,

     

    For TITLE column, set summarisation to FIRST as highlighted below:

     

    For END DATE, set summarisation to LATEST as shiwn below:

     

    This will give you your desired result as follows:

     

    Thanks,

    Pragati

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

JSR , Try a measure like

 

measure =
var _date = today() //selectedvalue(date[date])
return
calculate(counrows(Table), filter(Table, table[start date]<=_date && Table[end date]>= _date))

  • JSR's avatar
    JSR
    Icon for Helper II rankHelper II
    6 years ago

    Thanks amitchandak 

    but I dont think a measure will work, I need to display diferrent coulumns of the row.