Forum Discussion

estgas's avatar
estgas
Frequent Visitor
8 years ago
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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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] ) )
    )
)

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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] ) )
    )
)