Forum Discussion
Dates
scenario:
there is start, due and due revised dates columns
However, the due revised column has empty cells.
Question: how to configure due revised and due date columns as one with keeping data from due and replacing the "old dates" from due on due revised?
Thank you in advance
Hi Anonymous,
I would suggest to create a new column with an if logic according to your needs, Maybe something like this?
TomsNewColumn = IF ( Table[Due Date revised] = blank(), Table[Due Date], Table[Due Date revised] )
Let me know if this helps! 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
2 Replies
Hi Anonymous,
I would suggest to create a new column with an if logic according to your needs, Maybe something like this?
TomsNewColumn = IF ( Table[Due Date revised] = blank(), Table[Due Date], Table[Due Date revised] )
Let me know if this helps! 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Do this in Power Query. You can create a new conditional column with whatever logic you want, then load that. But I don't know what "how to configure due revised and due date columns as one with keeping data from due and replacing the "old dates" from due on due revised?" means.
Give us some sample data and a mock up of expected results.How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
