Forum Discussion
Solved
First value / approval
Hello, could anyone help me please with following: I have a table where entities are approving a report. Some entities once (MFR), some several times (PHD). I need to calculate the FIRST REPORT...
Youn need the first reported time:
First Reported Time = CALCULATE ( MIN ( 'Table'[Update Time] ), ALLEXCEPT ( 'Table', 'Table'[Model], 'Table'[Entity], 'Table'[Period] ) )
KatkaS I guess in case of entity F, you want updated time, minimum time from both the records or you want the first record, if you want updated time from first records, what identifies the first record?
Hello Parry,
in case of entity F, I only want first record - first record is the one that comes first timewise - in column UPDATE TIME (in case of entity F first is UPDATE TIME at 15:56:24).
I hope it clearer now.. thank you!
KatkaS I thought so too and that's why I didn't want to give any solution. So my question was, is there any identifier which record is first, if not then you need to add an index column in power query? Let's start here and then we can get to the solution.