Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create Table from multiple rows

I have a table currently that I want to create a unique row for an ID for with the columns where values are not null, have that date.  See table below (current table) and then see what I am trying to...
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi @LaurenTSloa 

you can plot a table visual with the mentioned three columns directly and choose latest for both data columns, like:

 

or you create a calculated table with:

tbl2 = 
ADDCOLUMNS(
    VALUES(tbl[REF_ID]),
    "IA Date", CALCULATE(MAX(tbl[IA Date])),
    "SDO Date", CALCULATE(MAX(tbl[SDO Date]))
)

it worked like: