topic Re: Create a DAX with several conditions in DAX Commands and Tips

Create a DAX with several conditions

Anonymous — Mon, 06 Jul 2020 17:16:31 GMT

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.

Re: Create a DAX with several conditions

amitchandak — Mon, 06 Jul 2020 17:35:03 GMT

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)

Re: Create a DAX with several conditions

Anonymous — Tue, 07 Jul 2020 08:25:21 GMT

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.

Re: Create a DAX with several conditions

Anonymous — Tue, 07 Jul 2020 09:02:19 GMT

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