Power Query (M)Power Query & M
← All topics
Power Query & M

Power Query (M)

Shaping, folding and the M language across Excel & Power BI.

5this week
39last 30 days
9sources
Most activer/excel 13r/PowerBI 12MrExcel Message Board 5Power BI Blog 2Stack Overflow — [powerbi] 2
Weekly Power Query (M) briefing

The few items worth your time, every Tuesday. Nothing else.

Free. One email a week. Unsubscribe in one click. · RSS

Latest in Power Query (M)

03

PQ: how to copy cell over and down

Hi All, I am trying to set up a power query template. Take a couple of cells that need to be moved over and copied down. For example, I would need cell E41 to be moved down to D43 and D44, then delete the row E41. And…

Q&A Formulas & Functions · r/excel ·
06

Double Counting in Daily Snapshot Data

Problem: Double Counting in Daily Snapshot Data (Power Query / Power BI) I'm appending daily ERP snapshot reports into one Master Table using Power Query. However, the same Order ID appears in multiple daily reports…

Q&A Formulas & Functions · r/excel ·
08

Snapshot of Power Query workbook?

How can you take a snapshot of data in a workbook with power query? I want to to make a "frozen copy* that no longer updates from the source data. At work we each month get a report with about 42000 rows and 33 columns…

Q&A Formulas & Functions · r/excel ·
13

Power Query failure- excel for web

I have a resource tracking sheet for my group that pulls in check-in data from a forms response, runs a few power queries on the data, and returns the contact info etc. The workbook is hosted on a SharePoint site and…

Q&A Formulas & Functions · r/excel ·
17

Looking for a new laptop

Hi there, I’m looking for a new laptop, primarily for data analysis. I currently use a MacBook, but as you know, I can’t run Power BI Desktop on it, so I have to rely on my work PC whenever I need to use it. I’ve also…

Q&A Power BI Service · r/PowerBI ·

Related topics