Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
Gao,
Thank you it works
Oded Dror
Check out the July 2025 Power BI update to learn about new features.