Dynamic data load in Power BI using Advance editor

[Anonymous]

Hello Experts,

I am using SAP BW as source to load the data in Power BI. I have created vairables in SAP BW Bex query level and given inputs to load the data. Everything was working fine with static inputs.  Now I am looking for the dynamic data load for last 90 days always.

Is there any way to load the data dynamically using advance editor. Kindly put some suggestions to resolve the issue.

Regards,

Ajay

[amitchandak]

@Anonymous ,

Before source create these two dates and use that where you are giving the dates

end_date = Date.From(DateTime.FixedLocalNow()),

start_date = Date.Adddays(Date.From(DateTime.FixedLocalNow()),-90) ,

Source = <Your code >