Hello how to keep some data from the last record to avoid retyping the same data again exemple : I have a (sales table) and these column [date] [client] [product]
1rst record: I type these data [date],[client],[product]
2seconde record: I dont want retyping again [date] and [client ] i want to be kept from the 1rst record
Solved! Go to Solution.
Youโll need to use an Initial value expression:
This will get you the value of the Date column from the last row of the My Table table:
LOOKUP(
MAX(My Table[_ROWNUMBER]),
"My Table",
"_ROWNUMBER",
"Date"
)
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |