cancel
Showing results for 
Search instead for 
Did you mean: 

Equivalent of index, match

Hello,
please, can anybody advise me? Look at the data, they looks similar like in the picture. I need to add the right date for current level, where there is something different, it should be blank... I need to do this in Power BI..

Thank you,
Michal Capture.PNG

Status: Needs Info
Comments
Moderator

@Michal ,

How do you write the Index&match formula in Excel? In Power BI Desktop, you can use lookupvalue instead.

There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Index-Match-equivalent-same-query/td-p/561936



Regards,
Lydia

Moderator
Status changed to: Needs Info