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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi tarolz132q ,

How to get the 05/26/22 - 156?

Create a measure.

Measure = VAR _DAYS= COUNTAX(FILTER(ALL('Table'),'Table'[date]=SELECTEDVALUE('Table'[date])),'Table'[date])
VAR SUM_=CALCULATE(SUM('Table'[COIN_BALANCE]),FILTER(ALL('Table'),'Table'[date]=SELECTEDVALUE('Table'[date])))
RETURN
SUM_/_DAYS

If I have misunderstood your meaning, please provide more details with your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.