Mar 25 2023 11:51 AM - edited Mar 27 2023 11:30 AM
Hello this thread is not active because the data in the files I posted were not accurate and caused a lot of trouble please go to the new thread were I corrected the data in this link thank you.
Mar 25 2023 01:09 PM
w/modified column used in the math:
=MAP(Table1[Close Date],Table1[Created on],Table1[Modified On],LAMBDA(h,i,j,IF(ISBLANK(h),j-i,h-i)
w/TODAY() function used in the math (This changes the results considerably):
=MAP(Table1[Close Date],Table1[Created on],LAMBDA(h,i,IF(ISBLANK(h),TODAY()-i,h-i)))
If this is what you're looking for and want to put the 'timeline' in the table, then we'd go with a logical IF and forget MAP. Outside of the table, MAP's results are dynamic based on the table.
Mar 25 2023 01:12 PM
Do you really want to calculate CreatedOn minus today? You get a of lot negative values.
And there is something wrong with your dates. Some of them are in the future.
Mar 25 2023 01:46 PM
Mar 25 2023 01:56 PM
Then it is simply:
=MAX([@[Close Date]],TODAY())-[@[Created on]]
Future dates will have negative values.
Mar 25 2023 01:59 PM
Mar 25 2023 04:38 PM
Mar 25 2023 06:01 PM