Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@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)
@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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |