Daily AVG

[netanel]

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!

[Jihwan_Kim]

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]

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

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?

[netanel]

@Jihwan_Kim 

I tried to make it as clear as possible, thanks!

Here you have the simple file:

https://1drv.ms/f/s!AonyYI-TdspHgUhwngZ6OKvpnSsc

[Jihwan_Kim · Accepted solution]

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]

@Jihwan_Kim 

Oh man how did I not think of that

So simple so good
Thanks!