Forum Discussion

goyalsa's avatar
goyalsa
Icon for Helper III rankHelper III
5 years ago
Solved

compare two table based on highest week

Hi,   Is there any way to calculate by taking the highest "Week forecast filled in" from the demand sample table and compare the customer in demand sample table with the customer in the order sampl...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    goyalsa , the expected output is not clear.  Also you need a common week and country table

     

    measure you can use with common country

    M1 =

    sumx(values(Country[Country]), lastnonblankvalue(order[Loading week]), Count(Order[order]))

     

    M2=

    sumx(values(Country[Country]), lastnonblankvalue(Demandside[week forecating filled in]), Count(Demandside[Demand]))

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

goyalsa , the expected output is not clear.  Also you need a common week and country table

 

measure you can use with common country

M1 =

sumx(values(Country[Country]), lastnonblankvalue(order[Loading week]), Count(Order[order]))

 

M2=

sumx(values(Country[Country]), lastnonblankvalue(Demandside[week forecating filled in]), Count(Demandside[Demand]))

  • goyalsa's avatar
    goyalsa
    Icon for Helper III rankHelper III
    5 years ago

    Hi amitchandak,

     

    I am trying to compare the loading week, the hub from both tables and want the forecasted demand number in the order table.  

     

    So, I can figure out demand forecasted v/s order allocated for that week and from the hub.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

      Could you please show the expected result.

      • goyalsa's avatar
        goyalsa
        Icon for Helper III rankHelper III
        5 years ago

        Hi, Ashish_Mathur,

         

        Thank you for your response. It is solved now. 

         

        Looking forward to your help in the future.

         

        Safe regards,

        Sahil