Forum Discussion

Julianvesga's avatar
Julianvesga
Frequent Visitor
6 years ago
Solved

Function to Get a result from 2 conditions

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
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Julianvesga ,

     

    We can create a calculated column with following formula to meet your requirement:

     

    COT =
LOOKUPVALUE (
    'Mapping'[COT (cutofftime)],
    Mapping[Country], [Country],
    Mapping[Subproceso], [Subproucto]
)


    If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

venal's avatar
venal
Icon for Memorable Member rankMemorable Member
6 years ago

Julianvesga 

Please refer the link with the PBIX file.

 

If you have any queries or concerns, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Julianvesga's avatar
Julianvesga
Frequent Visitor
6 years ago

Hi

 

thank for your reply but i can get of link, could you please copy in this message.

 

thank you