Forum Discussion

sparkplug93751's avatar
sparkplug93751
Helper II
6 years ago
Solved

Average Day Per Month

Hello,    I have a data set that logs each time somebody signs in.   Everytime somebody signs in, a row is created ie if 15 people sign in then 15 rows are added.   I want to calculate the aver...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    sparkplug93751 ,

    Assume your logic is correct

    if(hasonevalue(table1[monthend], 
averagex(summarize(table1[date],"_1",calculate(count(table1[names]),not(isblank(table1[occupation])))),[_1])
,calculate(count(table1[names]),not(isblank(table1[occupation]))))
amitchandak's avatar
amitchandak
Super User
6 years ago

sparkplug93751 ,

Assume your logic is correct

if(hasonevalue(table1[monthend], 
averagex(summarize(table1[date],"_1",calculate(count(table1[names]),not(isblank(table1[occupation])))),[_1])
,calculate(count(table1[names]),not(isblank(table1[occupation]))))