conditional column or if statements

[manishsalanke]

hi...team we have a conditon in which we have many columns for example - 1 approver , 2 approver ,3 approver ,4 approver ,1 approver date ,second apporver date ,3 aprover date ,4 approver date ,created date ..................now we want to create a conditonal column which will show 1 approver by diffrence in created date and approver date need to show it like wise 

[Idrissshatila]

Hello @manishsalanke ,

if you're asking what's the best approach to do it, then do it in power query using a conditional column.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[manishsalanke]

without useing power query

[Idrissshatila]

@manishsalanke , then it should be dine as a calculated column.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[manishsalanke]

can u help with quary