Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
I have a table that is currently looking at data from 2021 in column TRANSACTION_DATE.
I would like to filter this in Power Query M to Transaction_Date is >= 2 years previous (which will change next year to 2024, 2025, 2026 etc), so would see 2023, 2024 and 2025 this year.
Cannot figure out how to do this within the applied steps formula.
Your help would be appreciated.
Many Thanks
Alex
Solved! Go to Solution.
Managed to find the solution....
Table.SelectRows(#"Changed Type", each [TRANSACTION_DATE] >= DateTime.Date(Date.AddYears(DateTime.LocalNow(),-2)))
Hi @villa1980 ,
In power query, please add a new custom column using this M code to get the year:
Date.Year([TRANSACTION_DATE])
Now in APPLIED STEPS, right click in last step and inser step after with this M code:
= Table.SelectRows(#"Added Custom", each [Custom] >= Date.Year(DateTime.LocalNow()) - 2)
This will dynamically adjust each year and include data for the last two years plus the current year.
Hi @villa1980 ,
In power query, please add a new custom column using this M code to get the year:
Date.Year([TRANSACTION_DATE])
Now in APPLIED STEPS, right click in last step and inser step after with this M code:
= Table.SelectRows(#"Added Custom", each [Custom] >= Date.Year(DateTime.LocalNow()) - 2)
This will dynamically adjust each year and include data for the last two years plus the current year.
Managed to find the solution....
Table.SelectRows(#"Changed Type", each [TRANSACTION_DATE] >= DateTime.Date(Date.AddYears(DateTime.LocalNow(),-2)))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |