Last seen: Apr 30, 2025
See if this works for you let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each ([Pair...
If I understand correctly then, Power Query will do the work let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...
We cannot manipulate data in a picture. Please repost your file as an attachment.
CTL + ; will give you the current date CTL Shift + : will give you the current time
Suggest you post a sample workbook as an attachment. 8 to 10 records. Then mock up the expected solution for what your issue is. This way we do not...
You are welcome Elizabeth.
Since you did not provide expected results for your moving average, my results are done in Power Pivot with a measure. See the attached file for the ...
I had no issues in loading the data to PQ and then closing and loading to PP (DM). However when I looked for common fields in PP, I found that one ta...
Your version of Excel may have become corrupted. You may have to re-install it to allow PQ to work.
When I do what you want, it does not present as you have shown. Help us to help you and not make more work for me to help you.
It would be very helpful if you posted your sample data in a workbook and attached it so that we can see your data and then mock up what you want your...
Change it to currency after you replace the nulls.
You can achieve this with Power Query or if you have O365 the GroupBy Function Power Query let Source = Excel.CurrentWorkbook(){[Name="tbl_te...
If column 3 is blank, then the Mcode will sort on the remaining two columns. See the example attached
A Power Query Solution let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Sour...