Forum Discussion
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
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.
4 Replies
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.
- 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.
