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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-cherch-msft

  • 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.