Forum Discussion
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...
Create a summary table...
SummaryTable = SUMMARIZE(TableName,REF_IDIA,"Date",MAX([Date]),"SDO Date",MAX([SDO Date]))