Calculated column that shows unique values and if a value isn't unique just shows them once

[RonaldvdH]

Hey Guys,

Is het possible to just show distinct values in a calculated column and if a value isn't unique then just show it once ?

I'm using this formula but I need to change the "Ja (=Yes)" so that is shows the Zappter[Functionele locatie Zappter] but only once and the only with the newest created date

Test = 
IF(
    COUNTROWS(
        FILTER(
            ZAPPTER,Zappter[Functionele Locatie Zappter]=EARLIER(Zappter[Functionele Locatie Zappter]))) > 1, 
            "Ja",Zappter[Functionele Locatie Zappter])

Functionele locatie	Created date	Test
0000AT|10||	01-03-24	0000AT|10||
0000AB|2|A|	01-03-24
0000AB|2|A|	15-07-24	0000AB|2|A|
0000AA|48||	25-03-24	0000AA|48||
0000AB|9||	10-01-24	0000AB|9||
0000AA|100|A|	05-06-24
0000AA|100|A|	14-07-24	0000AA|100|A|

[v-nuoc-msft · Accepted solution]

Hi @RonaldvdH 

For your question, here is the method I provided:

Here's some dummy data

"Table"

Create a column.

Test = 
VAR LatestDate = 
    CALCULATE(
        MAX('Table'[Created date]),
        FILTER(
            'Table',
            'Table'[Functionele locatie] = EARLIER('Table'[Functionele locatie])
        )
    )
RETURN
IF(
    'Table'[Created date] = LatestDate,
    'Table'[Functionele locatie],
    BLANK()
)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RonaldvdH]

@fooddor @amitchandak  do you have any ideas ?