Forum Discussion
Power Query
Can someone please tell me how I can preserve cell formatting even after I refresh my query! This would be extremely helpful for my work project right now! Thank you in advance. ( I have attached...
We speak about "Combine_Excel__2" query?
Here in query editor you may filter Hours column as
This step generates M code which you may see in formula bar
= Table.SelectRows(#"Changed Type", each ([Hours] <> "Hours"))
Thank you so much for your help - I was extremely over thinking the question!
Is it possible for me to have a Subtotal at the end of each dept that collapses without it pulling the Subtotal information into the Pivot table?
That's with Pivot Table or create one more query with departments subtolals (Group By) and land it separately.