Forum Discussion

tarolz132q's avatar
tarolz132q
New Member
4 years ago
Solved

Avg Balance DAX

Hi Folks, I would like to measure the Avg coin balance for each day. The challenge is to calculate only the newst coin balance for each date by USER_ID. if you notice, AF4FF96..... is shown twice! ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Please explain how you arrived at the ansers of 98 and 156.

tarolz132q's avatar
tarolz132q
New Member
4 years ago

please see my new reply

 

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

     

    Avg = 
var d = SELECTEDVALUE('Table'[DATE])
var a = calculatetable(SUMMARIZE('Table','Table'[USER_ID],"md",max('Table'[DATE])),'Table'[DATE]<=d)
var b = ADDCOLUMNS(a,"mb",var md=[md] return CALCULATE(sum('Table'[COIN_BALANCE]),'Table'[DATE]=md))
return  divide(sumx(b,[mb]),countrows(b),0)