title: Model data source - Power BI
body: <p>I'm trying to model a data source in power bi, but I'm not getting it.</p>
  
  <p>Could you help me with alternatives so I can create a new column? The data source is in excel and brings the data with subtotal by types (XPTO, XPT, etc). I want to put these types as corresponding values ​​in the new column for your items. I tried via power query and dax, but I could not.</p>
  
  <p>Original Source:
  <img src="https://i.stack.imgur.com/N5rXK.jpg" alt="Original Source"></p>
  
  <p>Modifications Needed
  <img src="https://i.stack.imgur.com/pQRLz.jpg" alt="Modifications Needed"></p>
  
  <p><a href="https://1drv.ms/x/s!AuUNmh5pyq5g9QI_hoNQewiZRJ0b" rel="nofollow noreferrer">Source File</a></p>