Getting a string value based on the max date of another value

Hi jonclay ,

What type of data source are you connecting in which mode? For this type of error message, it may not be a formula creation issue. Rather, it has to do with the access rights to the data source or your connection mode.

Such as below:

Similar solutions:

powerbi - Power BI Direct Query : Couldn't load the data for this visual - Stack Overflow

Solved: Couldn't load data for this visual - Microsoft Power BI Community

If the problem is still not resolved, please provide the relevant test data, so that I can answer for you as soon as possible. Looking forward to your reply.

Best Regards,
Henry

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