Forum Discussion
VLOOKUP OR INDEXMATCH ALTERNATIVE TO FIND VALUE BASED ON CELL VALUE
This is what I have: ID Name 1 1 1 A 2 2 B 2 3 3 3 3 C And this is what I need: ID Name 1 A 1 1 2 B 2 ...
Hi,
Here is the project in excel.
the commands between BI and excel a quite the same
Thank you for your message. You are using Query, but mine is loaded as Data Model and use PowerPivot. How to do that using Data Model? There is no much feature to operate and find the solution.