Values function not working

[Anonymous]

Hello, I have a problem with values function. I have 3 columns: partner_id ; date_from ; user_id. In date_from column, there are dates: 1/1/2011 ; 4/1/2018 ; 10/1/2018. The main idea is to create dax formula that calculates for how long user was working with different partners and if that user is still working with partners now.

If I filter out in power querry just two different (distinct) dates from 'date_from' column , then my dax formula works without no problems and gives the correct result. If I filter out in power query three or more different (distinct)dates, then formula gives an error " a table of multiple values was supplied where a single value was expected."

My question is: how to rewrite this formula that new calculated column "Date_to" it could take three dates together and compare them?

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may just use MIN Function instead.

[Anonymous]

You saved so much time with that simple solution, thanks and it works very dynamically ! 🙂