topic Dates in DAX Commands and Tips

Dates

Anonymous — Wed, 23 Feb 2022 16:07:57 GMT

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

Re: Dates

tackytechtom — Wed, 23 Feb 2022 16:27:09 GMT

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/

Re: Dates

edhans — Thu, 24 Feb 2022 02:45:25 GMT

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.