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]))

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.