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] )
    )

     

az38's avatar
az38
Community Champion
6 years ago

KatkaS 

based on your example what result do you expect?

KatkaS's avatar
KatkaS
Post Patron
6 years ago

az38 I have to calculate how many reports were reported on time and how many were late (App deadline minus Update time)...

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi KatkaS 

    it still not completely clear, but you can try s measures like

    In Time = CALCULATE(COUNTROWS(Table), Table[Update Time] <= Table[App deadline])

    and

    Late = CALCULATE(COUNTROWS(Table), Table[Update Time] >= Table[App deadline])