Forum Discussion
Getting minimum value out of a calculated table column
In this scenario, if you [DatedTime] is a column, you can directly create a calculated column in User table to get the Min Date on User level.
If the [DatedTime] is a measure, you have to create a calculated table to SUMMARIZE() it into a column so that you can use MIN() function.
Regards,
Hi ofeklevy
Please try adding this calculated column to your event table
Column =
VAR MinDatePerUser =
CALCULATE(
MIN('events unique_events'[DatedTime]),
FILTER(
ALL('events unique_events'),
'events unique_events'[User Name]=EARLIER('events unique_events'[User Name])
)
)
RETURN DATEDIFF(DATE(2016,1,1),MinDatePerUser,MONTH) 
Hey Phil_Seamark
Thank you for the answer! I will try it when I have access to my network; however, I would like the indicator of how native a user is to be appear in my Users table (mostly for the sake of performance, as that table is much much smaller than the events table).
Do you know how to create that calculation there instead?
Thanks!
In this scenario, if you [DatedTime] is a column, you can directly create a calculated column in User table to get the Min Date on User level.
If the [DatedTime] is a measure, you have to create a calculated table to SUMMARIZE() it into a column so that you can use MIN() function.
Regards,