Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create measure depend on another table

Hi Good Morning everyone, everyone I m new to power bi so needs your help to create the measure. I'm trying it for the last 24 hours but couldn't get it right. please help me. I have tried the bel...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    To my knowledge, I think the below syntax is incorect.

    You may try to use the following formula to modify it :

       FILTER(

        Tariff_ExpTHC1,

       'Document Line'[Gross Weight]>=MAX(Tariff_ExpTHC1[From_Wt])

        && 'Document Line'[Gross Weight]<=MAX(Tariff_ExpTHC1[To_Wt])

        && 'Document Line'[LEO Date]>=MAX(Tariff_ExpTHC1[From_Date])

        && 'Document Line'[LEO Date]<=MAX(Tariff_ExpTHC1[To_Date])

        )


    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

To my knowledge, I think the below syntax is incorect.

You may try to use the following formula to modify it :

   FILTER(

        Tariff_ExpTHC1,

       'Document Line'[Gross Weight]>=MAX(Tariff_ExpTHC1[From_Wt])

        && 'Document Line'[Gross Weight]<=MAX(Tariff_ExpTHC1[To_Wt])

        && 'Document Line'[LEO Date]>=MAX(Tariff_ExpTHC1[From_Date])

        && 'Document Line'[LEO Date]<=MAX(Tariff_ExpTHC1[To_Date])

        )


Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.