Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX - Allocate Program Type

I am looking for some DAX syntax with the following logic

 

Table A - 

 

Columns - Work Order , Date Rec'd. Contract #, Net tons

 

Table B

 

Columns - Contract #, Net Tons, Program type

 

I am trying to allocate Program type to table A...the problem I'm having is Example - Contract # P-1234 has 10 work orders of X amount of tons and only a portion of those work orders should be allocated to a specfic progam.

 

Anyone have any thoughts....?

Need Help

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Any takers? I can provide further information if needed. 

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous

       

      Could you share your sample data and expected output which could reproduce your scenario so that we could help further on it?You can also upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

      How to Get Your Question Answered Quickly

       

      Regards,

      Cherie