If Equals Certain Text, return a Date in a separate column

[qliky88]

Hi, 

Have a column that contains materials for a project. I want to return the date a certain material was received on a dashboard. In Excel syntax it would be something like: 

If(Material = "Material A", RECEIVED_ON_DATE)

If anyone could help me with the correct syntax to return the date the material is received would be great. Also, would it be best practice to then display this date using the KPI widget? 

Thanks in advance

[Saravanan_Desingh · Accepted solution]

Try this as part of LOAD statement.

If(Material = 'Material A', RECEIVED_ON_DATE) As Date_Received

 If you have more Materials, then

If(Match(Material,'Material A','Material B'), RECEIVED_ON_DATE) As Date_Received

[qliky88]

You got it @Saravanan_Desingh  thank you 🙂