Forum Discussion
Andrew_na_lang
Helper V
Helper VHow 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 a card. Please help me.
Measure used:
Gap from sign up to First Order (HOURS) = Datediff('Key Measures'[Earliest Sign up], [First Order Date], HOUR)
Average gap = AVERAGEX( ADDCOLUMNS( VALUES( 'Table'[full_name]), "@val", [Gap measure]), [@val])
7 Replies
johnt75Super User
Average gap = AVERAGEX( ADDCOLUMNS( VALUES( 'Table'[full_name]), "@val", [Gap measure]), [@val])
Andrew_na_langjohnt75 I don't need a new column. I just need the total average of gap from sign up to first order.
- johnt75
Its not a column, its a measure. Put this measure on a card visual and it will show the average gap
- moizsherwani
Continued Contributor
Andrew_na_lang Assuming you want to get an average per "full_name", you could use an AverageX function such as
AverageSignup = AVERAGEX(values(full_name),[Gap from signup to First Order (Hours)])- Andrew_na_lang
moizsherwani actually what I need is the average gap (Total) not the average sign up.
