Create a new column using other Table's column in Power BI

[Anonymous]

Hi,

I am very new to Power BI.

I have an excel formula. I need to create the same in Power BI.

IF(G4 Approval Date>43009,IF(AND(Offer Number="",G4 Approval Date<>""),"Y","N"),"N")N")

But "G4 Approval Date" is coming from Table "A"

      "Offer Number" is coming from "Table B".

I am trying to create the formula in Table "A". but I am not able to use "Table B": "Offer Number" field. There is a relationship between "Table A" and "Table B"  as 1 to Many based on "Opportunity_Id".

Can someone please help me on that?

Thanks!

Regards,

Poonam

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You can try this formula:

G4 Approval without offer =
IF (
    Table1[G4 Approval Date] > 43009,
    IF (
        AND (
            CALCULATE (
                LASTNONBLANK ( Table2[Offer Number], 1 ),
                USERELATIONSHIP ( Table1[Opportunity_Id], Table1[Opportunity_Id] )
            )
                = "",
            Table1[G4 Approval Date] <> ""
        ),
        "Y",
        "N"
    ),
    "N"
)

Best regards,

Yuliana Gu