Forum Discussion
Solved
Distinct column/table where value in column DateIn is oldest date
Hello, I have a question regarding to filtering unique values in a table. In the sample below I have some cliënts with products attachted. In the column DateIn we see the date when they where reg...
Hi CornerACK
Create a calculated column in your original table
final = VAR mindate_client = CALCULATE ( MIN ( 'original table'[DateIn] ), ALLEXCEPT ( 'original table', 'original table'[ClientId] ) ) RETURN IF ( 'original table'[DateIn] = mindate_client, mindate_client, BLANK () )Best Regards
Maggie
PattemManoharAnonymous
Thanks so far for your help!
I came across another issue. Maybe you can also help me with that?
I also want a filter (likewise the answers you gave) in my table
I created an If statement where ClientId exists more then 1 time in my column ClientId.
If so I want the Column "Meting" to be filled with the MIN date (in above example 20160815). If it is the other date I want it to be empty in de column "Meting".
This way I don't need to create a new table. Is this possible and if so, how can I accomplish this?
Kind regards,
Corné
v-juanli-msft
Community Support
Community SupportHi CornerACK
Create a calculated column in your original table
final =
VAR mindate_client =
CALCULATE (
MIN ( 'original table'[DateIn] ),
ALLEXCEPT ( 'original table', 'original table'[ClientId] )
)
RETURN
IF ( 'original table'[DateIn] = mindate_client, mindate_client, BLANK () )
Best Regards
Maggie