Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Latest Date

EDIT -  Latest Date by 2 ID columns. Is that possible? I tried to concatenate the columns, but got an error "end of the input was reached" Please look for examples in message below. Ta! H...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Tried using this solution - https://community.powerbi.com/t5/Desktop/Get-Max-Date-of-2-Columns/td-p/459071

Giving me an error

 

A single value for column 'Date' in table 'Table1' cannot be determined.
This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

 

Measure =
CALCULATE (
    MAX ( 'Table1'[Call Date] ),
    FILTER (
        ALL ( 'Table1' ),
        'Table1'[StoreNameEN] = MAX ( 'Table1'[StoreNameEN] )
            && 'Table1'[UPCUnit] = MAX ( 'Table1'[UPCUnit] )
    )
))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

You can try to use following measure, it will get the last date based on filtered table records and grouped by current category and name fields.

Measure =
CALCULATE (
    MAX ( T3[Publish Date] ),
    ALLSELECTED ( T3 ),
    VALUES ( T3[Name] ),
    VALUES ( T3[Category] )
)

 

Regards,

Xiaoxin Sheng