Forum Discussion
Automatically deleting inputted weekly data with Power Query(M) that does not represent a full month
Hey all, I'm handling some data in a report and I was wondering how to do a computation while importing said data. The data is split up by "scenarios", which is further split up by weeks (or pa...
Hi Sam_Zeus ,
In you scenario, Please have a try to use Table.Group .
If it doesn't meet your requirement, Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
v-frfei-msft
From the following code I now have this:
let
Source = Oracle.Database(__),
#"Sorted Rows" = Table.Sort(Source,{{"SCENARIO_ID", Order.Ascending}, {"TIME_BUCKET_ID", Order.Ascending}}),
#"Table Grouping" = Table.Group(#"Sorted Rows", "SCENARIO_ID", {"All rows", each _, type table})
in
#"Table Grouping"
How do I:
A: Use the Table.RemoveFirstN inside these new mini tables?
B: Once I'm done with processing the data how to it revert it back to being one table?
