Create a DAX with several conditions

[Anonymous]

Hi all,

I've the table on the left and I want to obtain the table on the right.
Already use the SUMARIZEDCOLUMN and works fine if I don´t include the Activity field, but in that case, I only get the maximum Elapsed time but I do not know what was the Activity responsible for that.

[amitchandak]

@Anonymous , use this in place of activity

lastnonblankvalue(table[elapsed time],max(table[Activity]))

and for elapsed time do not use aggregation (do not summarize)

[Anonymous]

@amitchandak 

If I use something like:

New Table = SUMMARIZECOLUMNS (
                                    'Date'[Date],
                                    'Schedules[Client ID],
                                     FIRSTNONBLANKVALUE( Schedules [Activity], MAX ( Schedules [Time in Acivity] ) ) )

I get an error saying: The SUMMARIZATIONCOLUMNS function expects a table expression for argument '3', but a string or numeric expression was used.

[Anonymous]

@Anonymous

Please check your syntax of SUMMARIZECOLUMNS. You are not using it properly. Go to dax.guide/summarizecolumns to know how to use it.

Best
D