Forum Discussion
Average of Two columns by adding the second Column First row to the First Column
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
Make sure you are creating it as measure
5 Replies
- arvindsingh802
Community Champion
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)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
Make sure you are creating it as measure
Hi Anonymous,
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