title: Power BI - Merging multiple customer tables
body: <p><a href="https://i.stack.imgur.com/hwV2H.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hwV2H.jpg" alt="enter image description here"></a></p>
  
  <p>Connection Type: Direct Query to multiple sources so limited DAX available especially in Power Query load.     </p>
  
  <p>Data Model Query:  The Data model is not a perfect star schema but there is an attempt to separate tables into business processes and lookup tables. There are probably a few issues to discuss the current data model. I only have 1 question at this time.  </p>
  
  <p>My current goal is to generate a single summarised customer table to replace the current two tables that have some measure I need like the number of app customers, a number of total customers, date customer first accessed app etc. </p>
  
  <p>So I cannot merge the 2 customer tables and add calculated columns and measures at the import stage as power bi does not support or allow it and sql is out as I am using direct query. My plan is to create a summarised customer table using DAX summarise function on front end visual page, that has only the app customers and then measures like the total number of customers etc. Is this best practice or is there a better way of approaching this? Understand you would ideally do in sql, or power query but in these circumstances, I think this is the best way but wanted a second view.</p>