Multi Table Filter taking hours to update

[jbwestrock]

Hello community - you all have helped me many times indirectly, and requesting some direct help, please.

The below DAX is a filter across multiple tables, and with the file sizes being over 1MM lines, it is taking hours to update.

The goal is to eliminate time anomalies where the end time is before the start time,  and sum the time into the correct category.

I can't seem to work out another solution that would make this faster.  Your help would be greatly appreciated!

[Anonymous · Accepted solution]

Hi @jbwestrock ,

Please refer:

Solved: PowerBI takes more than 3 hours to update

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data