Forum Discussion
Lexi
4 years agoFrequent Visitor
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.
- 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.