Dynamic date Range

[odeddror]

Hi there,

I need to pull data from Date_Dim with Fiscal_Year is last year and Fiscal_Period is 01

So I wrote a SQL statement looks like that

Select * from Date_Dim

Where  FISCAL_YEAR >= year(getdate()) - 1 AND FISCAL_PERIOD = '01'

My Question i show to convert the where clause in Power Query?

Thanks,

Oded Dror

[Anonymous · Accepted solution]

Hi @odeddror ,

// Edited the formula to replace DateTime.FixedLocalNow() with DateTime.LocalNow().

Please add a new step like:

= Table.SelectRows(YourPreviousStepName,each [FISCAL_YEAR]>=Date.Year(DateTime.LocalNow())-1 and [FISCAL_PERIOD] = "01")

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 in the Power BI Forum

[odeddror]

Gao,

Thank you it works

Oded Dror