Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX formula for MTA

 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

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    5 years ago

    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])

     

     

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    5 years ago

    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])