Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can't find Name

I want to create a calculated table to return earlier date if the logic is true but I am getting a error saying can't find of the columns.  please see screenshort Table 2 = SUMMARIZE('Table'...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

 

Table 2 = SUMMARIZE('Table','Table'[Value],'Table'[Type],'Table'[State],'Table'[Date],"Measure",IF(AND('Table'[Type]="cs-accelerator-CS Accelerator Assessment",'Table'[State]="Failed"),CONVERT(MIN([Date]),STRING),"No"))

 

If your calculation (IF(...) ) work as measure it will work here.

If just want rename without any grouping then use selectcolumns

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak  thanks for your help, that works but returning everything from the main table I want to summarize , I would like to exclude Tpe, state as they are not making my output unique,

 

Please screenshot of what my output looks like, as you can see below, its returning two dates instead of returning just '14/01/2020' as the latest date:

 

 

 

Please see below what I would like my output to look like :

 

ValueMeasure
ee6080d4-8942-ea11-a812-000d3a86d7a328/03/2020 
a392711c-151c-ea11-a811-000d3a86d7a3No
82ddcb3c-eb11-ea11-a811-000d3a86d545No
0dd45e8f-a507-ea11-a811-000d3a86d6ba26/02/2020
d476000d-d20a-ea11-a811-000d3a86d545no
5e91e211-cd0a-ea11-a811-000d3a86d54514/05/2020 

 

 

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

    Anonymous , try to have a measure like this

    Measure =
    VAR __id = MAX ( 'Table'[Value] )
    VAR __date = CALCULATE ( MAX( 'Table'[date] ), ALLSELECTED ( 'Table' ), 'Table'[Value] = __id )
    RETURN CALCULATE ( Max ( 'Table'[date] ), VALUES ( 'Table'[Value ), 'Table'[Value] = __id, 'Table'[date] = __date )

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

       

       

      I am not sure am doing wrong, Can I have it in a calculated column?

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

        Anonymous , Missed ]

        Measure =
        VAR __id = MAX ( 'Table'[Value] )
        VAR __date = CALCULATE ( MAX( 'Table'[date] ), ALLSELECTED ( 'Table' ), 'Table'[Value] = __id )
        RETURN CALCULATE ( Max ( 'Table'[date] ), VALUES ( 'Table'[Value] ), 'Table'[Value] = __id, 'Table'[date] = __date )