DAX formula for MTA

[Anonymous]

 Hi there, I have a Sharepoint list (Infopath form) in which you can insert milestones, their start date, their planned end date and their new end date (if its different from the planned end date). After all I want to create an MTA with this data.  So what I want power query actually to do is, set the data of the new end date column to a new "report-column". Like when it is 1. October 2020 I want the data of the new end date column set to the column "01.10.2020" and so on. Is this possible? Thank you very much!! Jasmin

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

If "end date" is equal to "planned end date", will the "New end date" show "planned end date"? If yes, you could use pivot column to have a try.

= Table.AddColumn(#"Changed Type", "Custom", each if[New end date] = null then [Planned end date] else[New end date])