Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

earliest Date

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]))
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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