Forum Discussion
Solved
SummarizeColumns with FirstNonBlank
Hi! I would like to create a new table that summarizes Prod. and Cust. depending on last Date (for both Prod. and Cust). Please see an example below. For the second Prod. there is the same date for...
Hi estgas
Go to Modelling Tab>>>>NEW TABLE
New Table = SUMMARIZE ( TableName, TableName[Prod.], "Last Date", MAX ( TableName[Date] ), "Last Date Customers", CALCULATE ( FIRSTNONBLANK ( TableName[Cust.], TableName[Cust.] ), FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) ) ) )
Hi estgas
Go to Modelling Tab>>>>NEW TABLE
New Table =
SUMMARIZE (
TableName,
TableName[Prod.],
"Last Date", MAX ( TableName[Date] ),
"Last Date Customers", CALCULATE (
FIRSTNONBLANK ( TableName[Cust.], TableName[Cust.] ),
FILTER ( TableName, TableName[Date] = MAX ( TableName[Date] ) )
)
)
Many Thank Zubair! Exactly what I was looking for!
By the way I replaced SUMMARIZE with SUMMARIZECOLUMNS assuming that is preferred according to conclusion of https://www.sqlbi.com/articles/introducing-summarizecolumns/
HI estgas
Yes I believe
SummarizeColumns
or
combination of Summarize with AddColumns
is much faster than mere Summarize
