Average of Two columns by adding the second Column First row to the First Column

[manubk]

Hi Team,

I tried differet ways to get Average for the below data but was not possible to get the Dax foumula. Could some one help me in cracking this problem.

I have two columns named Checking as First column and First date Min as Second Column.

Problem - I need to get average by  considering the  First date Min column first row data in Checking column

Below is the example 

It need to get average as below 

[manubk]

@v-vpabbu  Marked as Accept as Solution.. Thanks for helping 

[v-vpabbu]

Hi @manubk,

Thanks @arvindsingh802  for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[arvindsingh802]

Not sure with your context, but if only need Average as highlighted then use below
Average = DIVIDE(SUM('Table'[Checking])+FIRSTNONBLANK('Table'[First date Min],TRUE()),COUNT('Table'[Checking ])+1)

[manubk]

@arvindsingh802  Thanks for your reply .. When i tried using the above formula value is getting 228120 as average .. Which i am supposed to get 523762 as above mentioned .. Can you please check and confirm 

[arvindsingh802 · Accepted solution]

Make sure you are creating it as measure