Forum Discussion

andra2's avatar
andra2
Helper I
4 years ago
Solved

Direct Query question - latest date

Hello,    I am using direct query for a table having let's say these values: Team  Strategy  Stock   Section   Created On X 1 C 1 1/27/2022 1:14 X 1 C 2 1/27/2022 1:15 X 1 C 3...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi andra2 ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want.

    1. Create a measure as below to judge if it is the latest created on date group by  team, strategy and stock

    Flag = 
VAR _latestdate =
    CALCULATE (
        MAX ( 'Table'[Created On] ),
        ALLEXCEPT ( 'Table', 'Table'[Team], 'Table'[Strategy], 'Table'[Stock] )
    )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[Created On] ) = _latestdate, 1, 0 )

    2. Apply a visual-level filter with condition "Flag is 1" to the table/matrix visual

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

if you have a date table you can use today funtion or you can use max function 

andra2's avatar
andra2
Helper I
4 years ago

and how today or max function will help? can you, please, write the measure I should be using?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi andra2 ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want.

    1. Create a measure as below to judge if it is the latest created on date group by  team, strategy and stock

    Flag = 
VAR _latestdate =
    CALCULATE (
        MAX ( 'Table'[Created On] ),
        ALLEXCEPT ( 'Table', 'Table'[Team], 'Table'[Strategy], 'Table'[Stock] )
    )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[Created On] ) = _latestdate, 1, 0 )

    2. Apply a visual-level filter with condition "Flag is 1" to the table/matrix visual

    Best Regards