Forum Discussion
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...
Hi Anonymous
You may add the index in query editor.Please check the file.
Regards,
Cherie
v-cherch-msft - What would be the best way to index this? I tried to index by work order# but they are not sequenitally related to a specfic contract or date.
Hi Anonymous
It's always best to post your data in text/tabular format in addition to a screen capture. People trying to help can then readily copy the sample data and run some tests if they need to.
Based on my test,the above formula can be used for my scenario as below.Attached the sample file.Please let me know what's the issue for your data.
Regards,
Cherie