Forum Discussion

razan_5r5's avatar
razan_5r5
Frequent Visitor
4 years ago
Solved

calculation

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, razan_5r5 ;

    Please try it.

    Percent = 
var _count30= CALCULATE(COUNT('Table'[patients]),FILTER(ALL('Table'),DATEDIFF([appointment time],[time seen],MINUTE)>30))
return DIVIDE(_count30,COUNTX(ALL('Table'),[patients]))

    The final output is shown below:

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

razan_5r5's avatar
razan_5r5
Frequent Visitor
4 years ago

i do not understand this step 

 1/24/60 * 30),1,0)
  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    Under the surface a whole day has a numeric value of 1 which is why date+1 gives you'd the following days date.

     

    1/24/60 is the decimal equivalent of 1 minute. 1 day divided by 24 hours divided by 60.

    Multiplying that by 30 gives decimal equivalent of 30 minutes.

     

    Finally the of statement returns 1 if the wait time was greater than 30 minutes and 0 otherwise. You can then sum that column in a power bi visual to give a count.