Forum Discussion
DAX - Allocate Program Type
Hi Anonymous
You may add the index in query editor.Please check the file.
Regards,
Cherie
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
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.
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
Hi Anonymous
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.
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