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 Checkin...
Make sure you are creating it as measure
arvindsingh802
Community Champion
Community ChampionNot 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