Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

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

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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