Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I need to extract last 1 year of data from source based on current date .
Thanks in advance for solution.
Solved! Go to Solution.
@AOD , add a filter like this in power query
= Table.SelectRows(#"Changed Type", each [Sales Date] <= DateTime.Date(DateTime.LocalNow()) and [Sales Date] >= Date.StartOfMonth(Date.AddMonths( DateTime.Date(DateTime.LocalNow()),-12)) )
Hi @AOD ,
When you use Power BI (at least these days), the default option after selecting your tables is Load. If you just load data directly, then the entire data rows in that table (it might be 20 years of data or 50 million rows), will be loaded into the memory.
Please try to use TransForm data.
Then filter the data in Power Query according to date.
More details:Only Get the Last Few Periods of Data into Power BI using Power Query Filtering
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@AOD , add a filter like this in power query
= Table.SelectRows(#"Changed Type", each [Sales Date] <= DateTime.Date(DateTime.LocalNow()) and [Sales Date] >= Date.StartOfMonth(Date.AddMonths( DateTime.Date(DateTime.LocalNow()),-12)) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |