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 "Prev_Month_Days"

Can I say in the formula that if there is the number 31 in the row or 28 then divide by that number?

 

Thanks!

 

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]) )

     

6 Replies

  • 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?