Forum Discussion

KatkaS's avatar
KatkaS
Post Patron
6 years ago
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...
Need Help
  • zaza's avatar
    zaza
    6 years ago

    Youn need the first reported time:

     

     

    First Reported Time = 
    CALCULATE ( 
        MIN ( 'Table'[Update Time] ),
        ALLEXCEPT ( 'Table', 'Table'[Model], 'Table'[Entity], 'Table'[Period] )
    )

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

KatkaS ,

 

I have a table where entities are approving a report. Some entities once (MFR), some several times (PHD).

I need to calculate the FIRST REPORTED TIME (if it was late or on time comparing Update time and App deadline, this I'm able to do:)).

Could you please clarify more details about this requirement? For example, you can provide sample data using sheet format and give the expected result.

 

Regards,

Jimmy Tao