Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

IF AND statement from one table to another table

  I have a two tables are data and report.   In data table the following columns are A,B,C and status.   In report table the following columns are A,B and C.   In report table, I am trying to ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Saxon10 

    I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below for creating a new column.

     

     

    Status CC =
    VAR conditions =
    MINX (
    FILTER (
    Data,
    Report[A] <= Data[A]
    && Report[B] <= Data[B]
    && Report[C] <= Data[C]
    ),
    Data[A] + Data[B] + Data[C]
    )
    RETURN
    IF (
    CALCULATE (
    MAX ( Data[STATUS] ),
    FILTER ( data, Data[A] + Data[B] + Data[C] = conditions )
    )
    = BLANK (),
    "X",
    CALCULATE (
    MAX ( Data[STATUS] ),
    FILTER ( data, Data[A] + Data[B] + Data[C] = conditions )
    )
    )
     
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Saxon10 

Correct me if I am wrong,. in your Excel formula, The values in row one in the Report Table (250,250,160) are all less than their respective columns in Data Table on both KPI and KPI-1, but you show only KPI as the result where as KPI-1 is also true.

Please clarify.

  • Saxon10's avatar
    Saxon10
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Thanks for your reply. You are right and that's ture. I am taking which one is match first incidence. Is there any option in power bi how can I exact match (appropriate) respective columns in Data Table on both KPI and KPI-1 columns. 

    Can you please advise.