Forum Discussion
Solved
Return value based on time-stamp
I have tableA with date/time entries (Max 1 per second) I tableB with date/time entries (less frequent, no relation to other table) and at each time-stamp [VALUE] I'd like to return [VALUE] for eac...
Hi 123CaM321 ,
Regarding your question, is your connection mode Direct Query? After using DAX to create a calculated column, the query is sent to the data source, the data source returns all the data, and finally filtered by DAX. This may be the reason for the poor performance. You mentioned that you plan to implement it in Power Query. Please make sure that the steps applied support query folding, which will reduce the amount of data returned and thus improve performance.
Best Regards,
Wenbin Zhou
Thanks
Was more after a human response from someone with experience opposed to AI. I think I need to look into getting this done in power query as it's likely more efficient than DAX.