Forum Discussion

Julianvesga's avatar
Julianvesga
Frequent Visitor
6 years ago
Solved

Get a result from 2 condition and 2 different table

hi Team my question is how i can get a resul from 2 conditions, bellow have a Table Mapping thta is the guia to know what is the cutofftime by process and the second table is my daiy table that a ha...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Please create a column not Measure

     

    COT Column = maxx( filter(MappinG,MappinG[Country]=TABLE2[Country] 
&& TABLE2[Subproucto]>=MappinG[Subproucto]),MappinG[COT])

    Do table name swap if needed in the filter clause.

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

    My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Julianvesga's avatar
Julianvesga
Frequent Visitor
6 years ago

OMG...it worked...it worked perfect ... the symbol of < I corrected it.

thank you

 

Julianvesga's avatar
Julianvesga
Frequent Visitor
6 years ago

Hi, what about if i have 3 condition, for example to the table Mapping add a column denominate Product. is the same to he previous example but with 3 conditions.

 

this is my idea, but dont work: Table 1 = COT    Table 2= Citidocs DB

SystemCOT = maxx( filter('COT','COT'[COUNTRY]='Citidocs DB'[Country ID]
&& 'COT'[Product]='Citidocs DB'[Product.] && 'Citidocs DB'[SubProDes]='COT'[SubProDes]),'COT'[COT])

 

 

i hope oyu can help me.