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

     

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity 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])