Dax Formula

[Jedahn]

Hello Power BI Developers,

Good day. I have a question. I'm using this function in excel:
=IFERROR(XLOOKUP(C2,'Jan Interactions'!G:G,'Jan Interactions'!I:I),0)

C2 = Column in Sheet 1

Jan Interactions = Sheet 2 name

G:G = Column in Sheet 2

I:I = Column in Sheet 2

What Power BI formula i can use same with this? Please site some example.

Thank you very much

[Anonymous · Accepted solution]

Hi @Jedahn ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

sheet1:

Jan Interactions

(2) We can create a  calculated column.

Column = IFERROR( LOOKUPVALUE('Jan Interactions'[I],'Jan Interactions'[G],'Sheet1'[C2]),0)

(3) Then the result is as follows.

Please refer to the document for more information.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[amitchandak]

@Jedahn , refer

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8