I'm trying to create a new custom column from a conditional statement and current date.
Next picture explains exactly what i need to get with power query.
An example of what I need from pseudocode is:
if [fecha fin de plazo]>=CurrentDate and [fecha CIERRE investigación]=null
then "string"
My biggest problem is I don't know how to extract the current date with PowerQuery.