Is there any way to save time from copying data from one sheet to another? In this specific case, you can use Excel's MATCH or VLOOKUP/HLOOKUP function. It can not only reduces the chances of error but saves tons of time also.
I could just do the transformation on the data in Excel first and use the FilterVal column as a filter in PBI, but this is not a good solution because I am tasked with connecting directly to the database from PBI so I cannot do my transformations in Excel first. EDIT: You'll need ...
Avoid the temptation to work in the Data view and create a bunch of calculated columns like you would think of when using Excel when you just add another column. Power BI is very different and that is not a good practice to get into. Try to use Power Query for transformations and bringi...