Forum Discussion
Solved
Calculate min date with multiple columns
Hello, I have a data table that looks like follows: User ID Product ID Usage Date User1 124 11/02/2019 User2 223 05/18/2020 User3 893 06/29/2019 User1 124 11/03/2019 ...
Thanks! I used the following column and it seems to work for me:
Min date =
CALCULATE (
MIN ( table[USAGE_DATE] ),
ALLEXCEPT ( table, table[userID], table[PRODUCTID] )
)
prita , create a measure like
and use in place of date
measure =
var _min = calculate(min(Table[Date]), allexcept(Table, Table[User Id],Table[Product ID]))
return
calculate(min(Table[Date]), filter(table, year(_min) = selectedvalue(table[date])))
Thanks! I used the following column and it seems to work for me:
Min date =
CALCULATE (
MIN ( table[USAGE_DATE] ),
ALLEXCEPT ( table, table[userID], table[PRODUCTID] )
)