To get Total in between categories.
Hi, I have a table like this in Sheet 1- And from the sheet 1, I want to create Page 2 in Power BI which is like in Sheet 2 below- Difference is here the Total is populated through Sum formula. Values have been achieved through Vlookup- How I can do the same in Power BI by Exporting Sheet 1 and creating Sheet 2 from Sheet 1. Thanks, Amit Kumar
Joining Salesforce Data to Excel Sheet Data
Hi everyone! I am looking to see if PowerBI supports joining two unrelated data tables into one project. I want to pull in data from a Salesforce sandbox, as well as an excel sheet. I then want to join this data into one table. I was able to do this with Tableau, so I'm hoping PowerBI has a way!
