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

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi goyalsa,

 

Could you give an example or describe your expected output in an excel spreadsheet?

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!