Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost 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
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please try using CONVERT function in order to convert text type to number type in a measure.

Thanks. 

  • netanel's avatar
    netanel
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Jihwan_Kim Thanks for the response

    I fix the question
    The problem is not in text or number format
    The problem is dividing by 31 or 28 depending on what is written in the "Prev_Month_Days" column

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      Thank you for your feedback.

      Sorry that it is difficult for me to know how the column [Prev_Month_Days] looks like.

      Could you please share the sample pbix file with how the expected numbers look like?