Forum Discussion

DanClarkson's avatar
DanClarkson
Regular Visitor
6 years ago
Solved

Creating a table based on data from other tables

Hi,

I'm trying to create a new table in Power BI based on information from other tables. I have used Power BI for a while and have created calculated columns etc in the past but I'm drawing a blank when trying to advanced to this. Below is a list of tables with some sample data in and then finally the table I want to create based on summary info from the others.

 

 

Below is how I would like the data to appear in the final table. The widget count column is simply a sum of the total Install Count per customer from the widget table. Current Version Count is total of the Current Version per customer from the Product Table where Current Version = Y. Legacy version count is a total of Current Version per customer from the Product table where Current Version = N 

 

Any help would be gratefully recieved as it is driving me mad.

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi DanClarkson ,

     

     

     

    Create 3 measures

     

    InsCount = SUM(WidgetTable[InstallCount])
     
     
    Current Version = CALCULATE(SUM(ProductTable[Quantity]),FILTER(ProductTable,ProductTable[CurrentVersion] ="Y"))
     
     
    Legacy Version = CALCULATE(SUM(ProductTable[Quantity]),FILTER(ProductTable,ProductTable[CurrentVersion] ="N"))
     
     
     
    Drag Customer and Customer ID from Customer Table.
     
    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi DanClarkson ,

     

     

     

    Create 3 measures

     

    InsCount = SUM(WidgetTable[InstallCount])
     
     
    Current Version = CALCULATE(SUM(ProductTable[Quantity]),FILTER(ProductTable,ProductTable[CurrentVersion] ="Y"))
     
     
    Legacy Version = CALCULATE(SUM(ProductTable[Quantity]),FILTER(ProductTable,ProductTable[CurrentVersion] ="N"))
     
     
     
    Drag Customer and Customer ID from Customer Table.
     
    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
     
    • DanClarkson's avatar
      DanClarkson
      Regular Visitor
      6 years ago

      Awesome seems to do the job and was a lot less complicated than me trying to create tempary tables as I was before.

       

      Thanks again