Forum Discussion

jschoot's avatar
jschoot
Regular Visitor
5 years ago
Solved

Simple Difference

Hello,   I am trying to make an report on how many people have been in a building. I have 3 counters and they count the amount of people that go in and out per 15 minutes. I am trying to get the di...
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi jschoot ,

     

    52000 records should be the issue, the formula will work for each rows and may filter all rows in calculation of each row(even though the VertiPaq engine will optimize this part of the calculation , but it is still a heavy work). And there is no aggregate function in your formula.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai