API string - always set year and week to latest

[radiator]

Hi everyone,

I have this API string that requeres year and week. Is there a way to always make it choose the latest, e.g. 2023 and 42 for this week, 43 next week? Like a MAX date function to put into the string somehow?

Best regards,

Ole

[lbendlin]

Date.WeekOfYear - PowerQuery M | Microsoft Learn

Date.Year - PowerQuery M | Microsoft Learn