Forum Discussion
Solved
Max Date Function for Date/Time
When I run this DAX query, it functions almost perfectly. I say almost because it works on date only, but i need it to work with the time that is in the date field as well. This works Previous Ad...
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.
Ditch your .[Date] 's
When I ditch the .[Date]'s it stops working completely. After some time, it returns an error that there isn't enough memory to perform that function.