All Content
Timespan
explore our new search
​
Integer Divide and using Power Query to convert groups of rows into the right layout for Power BI
Power BI
Feb 17, 2023 10:00 PM

Integer Divide and using Power Query to convert groups of rows into the right layout for Power BI

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 BI

How to convert groups of rows into the right layout for Power BI or Pivot Tables using Power Query

How to convert groups of rows into the right layout for Power BI or Pivot Tables using Power Query

Integer divide (also known as floor division) is a mathematical operation that divides two integers and returns the quotient rounded down to the nearest whole number. It's often used in programming languages to return an integer result from a division operation, unlike regular division which can return a decimal value.

Using Power Query to convert groups of rows into the right layout for Power BI is one way of transforming data for use in Power BI dashboards or reports. Using Power Query allows users to transform data quickly and easily by allowing them to group, filter, pivot and unpivot columns; split text values; add custom columns with formulas; merge queries together; and much more. This makes it easy for users who don't have extensive coding knowledge or experience using SQL or other query languages to manipulate their data according to their needs.

Questions and Answers about Power Platform/Power BI

Option so we'll click the advanced. Options. And here you can choose split into and then select rows

How to Merge Rows In Power Query

Use an aggregate function to group by one or more columns

How to combine rows in Power Query