Forum Discussion

Lexi's avatar
Lexi
Frequent Visitor
4 years ago
Solved

TABLE TOTALS Unable to add it

Hello,   I am wondering if anyone could help me with a table I have in Power bi. I am trying to get the average time below the blue line as in the Total but Average Total.     
  • v-henryk-mstf's avatar
    4 years ago

    Hi Lexi ,

     

    I did the test with the following reference:

    M_ = 
    VAR A =
        MAX ( 'Table (2)'[Column] ) - DATE ( 1899, 12, 30 )
    RETURN
        DATE ( 1899, 12, 30 ) + AVERAGE ( 'Table (2)'[Column] )


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.