MinString Date

[Vittore8]

hi, tell me please how i can use MinString(B) to get the result:
2020-01

now I get: 2019-01

I should get min a date where column A is not null

[Vittore8]

which function can I use, or use set analysis

[tresesco]

How is 2020-01 is the min date from your sample data?

[Vittore8]

this is the minimum date from column B that corresponds to column A not with empty values

[Vittore8]

make a selection only where there are there are values in column A

[tresesco]

Try this:

MinString({<A={"=Len(Trim(A))>0"}>}B)