Forum

crossposting: /p> and Please read this:-->/p>

A Sample worksheet with mocked up solution would be very helpful here. The worksheet should probably not have more than 20 records. No pictures as w...

Move your pivot table to a fresh worksheet. Apparently you have more than one PT on the same sheet and they are overlapping. If this is not the case ...

Thanks for the feedback

Here is an alternative Power Query Solution

It would be very helpful if you attached a sample file which is reflective of your actual file (no confidential material included). We can then work ...

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.