Forum Discussion

Andrew_na_lang's avatar
Andrew_na_lang
Icon for Helper V rankHelper V
4 years ago
Solved

How can I get the average GAP (last Column)

Hi Friends,   I have created a measure that shows the gap in hours between the (Earliest Sign up) 2nd column and (First order date)3rd column. I now need to know the average gap to visualize it as ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago
    Average gap = AVERAGEX( ADDCOLUMNS( VALUES( 'Table'[full_name]), "@val", [Gap measure]), [@val])
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Its not a column, its a measure. Put this measure on a card visual and it will show the average gap

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    You need a close ) after the measure ], then delete the extra ) at the end of the line