Forum Discussion
Max Date Function for Date/Time
If you remove .[date], the loop number will be very large which may cause memory exceeding. You should modify your model structure or reduce the date table rows. You can refer to the doc and blogs below about how to improve the performance:
Optimization guide for Power BI
A comprehensive guide to Power BI performance tuning
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you remove .[date], the loop number will be very large which may cause memory exceeding. You should modify your model structure or reduce the date table rows. You can refer to the doc and blogs below about how to improve the performance:
Optimization guide for Power BI
A comprehensive guide to Power BI performance tuning
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your response. I reduced some of the rows and tweaked a couple optimization points and the query, although still a little slow, worked just as intended.
