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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-cherch-msft above is a sample of the two tables and desired results. Apologies, I clicked post a little too quickly. 

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

    Hi Anonymous

     

    You may link the two table first. Then you may create the calculated columns like below. Attached the sample file for your reference.

    Regards,

    Cherie

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-cherch-msft one last twist...:) In our line of business we recieve multiple deliveries on the same day....We have a unique ID (work order #) for each load. How would we work around this? 

       

      The function created in the attachment doesn't seem to calculate correctly given duplicate dates. 

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

        Hi Anonymous

         

        The way around this would be to create an index column to provide the uniqueness of rows. Use the index column in calculated column instead of the date column.If you need further help,please share a simplified data sample.

         

        Regards,

        Cherie