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

amitchandak's avatar
amitchandak
Super User
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