Forum Discussion

BNB2022's avatar
BNB2022
Copper Contributor
Dec 17, 2022

How to reference data by a name and a date

Hello,           My organization sends out a ton of reporting to track various things, but none of it is centralized. I have a spreadsheet that collects a lot of this reporting and centralizes it. A...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 18, 2022

BNB2022 

 

Another alternative (attached) with Power Pivot after:
- Filling the Source [Name] column with Power Query
- Establishing a relationship between TeamList & Source tables

 

 

Any in case what will always cause you problem(s) is the missing info. in the [Name] column of your Source table...

Resources