6 Replies Latest reply: Sep 20, 2016 8:56 AM by Nelly Lukina RSS

    Show only last date data with condition

    Nelly Lukina

      Hi, please, help, i`m stacked..

      I`m trying to create table with all measures for the last day(14/09/16) with condition. I have the table like thew attached. 4 Dimensions  -Measure, isAnomally, Date and scor3e. I need to create a table only with the measures and score that on max(date) IsAnomally<>0.

      I tried FirstSortedValue(Date,-Date) or FirstSortedValue(Measure,-Date) doesn`t work

      if(date=max(date),Measure) doesn`t work

      Will be glad to hear your ideas, thanks