Hi.
I have a column [AM/PM Charge] in Table Operations_Master_Check and I want the initial value of this to be the same as the row in the table with the MAX() [Pre-Treatment Timestamp]. This MAX() timestamp is not necessarily the maximum row in the table so I cannot use MAXROW(). I tried a virtual column with App Formula MAX(SELECT(Operations_Master_Check[Pre-Treatment Timestamp],TRUE,TRUE)) and set the initial value in the [AM/PM Charge] column to [Max Pre-Treatment Timestamp].[AM/PM Charge] but I am getting the following error.
Column Name โAM/PM Chargeโ in Schema โOperations_Master_Check_Schemaโ of Column Type โEnumโ has an invalid Initial Value of โ=[Max Pre-Treatment Timestamp].[AM/PM Charge]โ. Error in expression [Max Pre-Treatment Timestamp].[AM/PM Charge]
Any help in the right direction on this would be great, thank you.
User | Count |
---|---|
44 | |
34 | |
24 | |
23 | |
15 |