Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating Secondary Table that will Add Multiple Rows together for an Attribute

Hello, I need to aggregate multiple rows of a file together to get one total for each attribute (a person). Ex: this is the main data set and connections to a key/date dimension: I want to crea...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    Anonymous you shared data in your screenshot. I'm just asking you to share it in a usable format that we can copy and paste into Power BI. As for grouping, it is on the Home Ribbon in Power Query:

     

    How to get good help fast. Help us help you.
    How to Get Your Question Answered Quickly - Give us a good and concise explanation
    How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

     

edhans's avatar
edhans
Community Champion
5 years ago

You can usually do the math in Power Query - usually. I'd need to see the formula.

You can reference measures in other measures.

Unit Price = 
SUMX(
   Sales,
   DIVIDE(
      [Gross Sales],
      Sales[Quantity]
   )
)

There I am calculating the unit price by dividing the Gross Sales measure by the unit price, iterating over the sales table.

 

I would be more than happy to help. But I need data. And the formula for your calculated column. I'll respost the links on getting help.

 

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

edhans sorry, should have addressed this in the first response. unfortunately my organization does not allow me to utilize onedrive, dropbox, or any other means to "share" data. 


If you can point me in a direction of what you meant by "a grouping operation" I'm happy to investigate further myself.. I just don't know what that means.