Forum Discussion

Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
6 years ago
Solved

Filter rows without filtering date columns

Hi There,   I have a matrix with dates for columns and ID's for rows and the values are text inside which only appear when an ID meets a certain condition (inputted into the raw data).    The iss...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Hayleysea ,

     

    Please create a calculated column as below.

    Column = 
VAR maxdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( 'Table', 'Table'[ID] = EARLIER ( 'Table'[ID] ) )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[Status] ),
        FILTER (
            'Table',
            'Table'[Date] = maxdate
                && 'Table'[ID] = EARLIER ( 'Table'[ID] )
        )
    )

     

    For more details, please check the pbix as attached.

     

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey Hayleysea ,

 

please create a pbix file that contains sample data, but still reflects your data model. Upload the pbix file to onedrive or dropbox and share the link. Don't forget to describe the expected result.

 

Regards,

Tom