dynamic source path for link as per condition

[Anonymous]

Source image

Hi,

There is a condition where i need to change the source dynamically. This is the current source link for my odata source "http://SAP.COM:9086/sap/odata/MDG_CDS/MDG(p_date='20200101')/Set" . The condition is to take previous two calender years data. When we are in year 2023 the link must be  "http://SAP.COM:9086/sap/odata/MDG_CDS/MDG(p_date='20210101')/Set".

The p_date=2021 part of the link must change dynamically when we are in year 2023 .

p_date=2022 when are in year 2024 and so on

This is the condition which i must appy to get data in dynamic way . How can this be achieved?

[v-cgao-msft]

Hi @Anonymous ,

Please refer to Sergei's answer:

Power Query from dynamic URL

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data