earliest Date

[Anonymous]

i am try to calculate when a customer needs to order by.  In the release data there are multiple dates... i need to select the earliest post current date and them subtract off the lead times.  What i have works some times but not every time.

i.e. -1/15/2023 -10 days lead time = 1/5/2023

Order Date =

Calculate(Sum('Release_Data'[Available Date])) - (Sum('Statuscheck'[Lead Time]))

[v-yiruan-msft]

Hi @Anonymous ,

Could you please provide some sample data in your tables 'Release_Data' and 'Statuscheck' (exclude sensitive data) with Text format and your expected result with backend logic and special examples? Is there any relationship between them? If yes, please provide the relationship info. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[pranit828]

HI @Anonymous 

Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.