Forum Discussion
Date Diff. Using Today() function
so I understand what you asking, what is the objective of your formula?
to check if there is date, if there is and its < than today, run the date diff and return a day value, otherwise, if not then put the text in the same column 'days next due'? or are you trying to name the column?
vanessafvg The objective of the formula is:
Excel Formula: IF(D2<TODAY(),DATEDIF(D2,TODAY(),"d"),"Days Next Due"))
The D2 cell has next due date for the equipment and if it < today's date then result would be the text "Days Next Due" intend of empty cell.
and if the next due date for the equipment > today's date then result would be the "Number in days like: 127, 70..."
As you can see in power bi image there are so many empty cell are there but in excel sheet it's occupied. If it is possible, my report would be very easy to understand for the user.
Please find attached photo
vishalbaldania its because you are mixing your data types, you are getting a numeric calculation but you want to then put a text in the column. This is where its different to excel because excel wont mind but power bi will. You will need to come up with a numeric indicator for days next due like -1 or something.