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

     

zaza's avatar
zaza
Resolver III
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] )
    )

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    zaza that would work but only in case if KatkaS looking for minimum value across all those 3 columns, but if the requirement is first entry then it will not work, and that was the question I asked. 

  • KatkaS's avatar
    KatkaS
    Post Patron
    6 years ago

    zaza Thank you!! This is exactly what I needed.. thank you for solving this despite my blurry explanation, but I really did my best:) 

    parry2k , az38 , v-yuta-msft Thank you for you time too!!