Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago
Solved

Daily AVG

Hi All, Tricky problem I am trying to create a daily average for IAA Amount The problem is that I don't really have 31 days in the data but I have the number 31, Only in one row under column "Pre...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please try writing the below measure and put it into the same visualization whether it suits your requirement.

     

    AVG IAA = 
DIVIDE( [IAA 40_BT40002 Revenues_Ads], SELECTEDVALUE( Dim_Time[Current_Month_Days]) )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please try writing the below measure and put it into the same visualization whether it suits your requirement.

 

AVG IAA = 
DIVIDE( [IAA 40_BT40002 Revenues_Ads], SELECTEDVALUE( Dim_Time[Current_Month_Days]) )

 

netanel's avatar
netanel
Post Prodigy
4 years ago

Jihwan_Kim 

Oh man how did I not think of that

So simple so good
Thanks!