All Content
Timespan
explore our new search
Power Query formula writing using the SHIFT SHUFFLE
Power BI
Jun 28, 2023 8:30 PM

Power Query formula writing using the SHIFT SHUFFLE

by HubSite 365 about Wyn Hopkins [MVP]

Microsoft MVP | Author | Speaker | Power BI & Excel Developer & Instructor | Power Query & XLOOKUP | Purpose: Making life easier for people & improving the quality of information for decision makers

Data AnalyticsPower BIExcel

Using SHIFT 🔽 SHIFT 9️⃣, SHIFT ▶️ to wrap functions when writing M code


I apologize, but as of my knowledge cutoff in September 2021, there is no specific function or concept called "SHIFT SHUFFLE" in Power Query. It's possible that this term refers to a technique or approach that has emerged after my knowledge cutoff date.
 
However, I can provide you with information about Power Query and its formula writing capabilities. Power Query is a data transformation and query language used in Microsoft Excel, Power BI, and other tools. It allows you to extract, transform, and load data from various sources into a structured format for analysis and reporting.
In Power Query, you can use a range of functions and operators to manipulate and transform your data. These functions can be combined in a formula using a functional language called M. The formula language in Power Query is similar to Excel formulas, but it provides more advanced features for working with structured data.
 
To perform transformations on your data using Power Query, you can follow these steps:
Importing the data: Start by connecting to the data source you want to work with. Power Query supports a wide range of data sources, including databases, files, web services, and more. You can import the data into the Power Query Editor.
Applying transformations: Once the data is imported, you can apply various transformations to clean and reshape it. This includes filtering rows, removing duplicates, splitting columns, merging tables, and performing calculations.
Formula writing: Power Query formulas are typically written using the formula bar in the Power Query Editor. The formula bar allows you to write and edit M formulas directly. M is a functional language that supports a rich set of operators and functions for manipulating data.