Forum Discussion
Need your help to create a timeline column
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. htt...
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.
- wow thank you so much Patrick i tried the second formula and it worked perfectly, but just a question how will the formula differ if we use IF instead of MAP and yes I'm intending to use your formula inside the same table.
- If the formula is going in the table, then go with IF. The results of MAP spill and tables are scalar-based (1 cell, 1 formula, 1 return).
- yes when i try to do it in my dataset it gives me SPILL error could you please show me how i can do it with IF
