Power Query Column IF Statement

[HenryJS]

Hi all,

How can I create a Power Query IF Statement that states:

if [combined insurances] >= today then "Yes"

OR

if [Professional Indemnity Insurance] AND [Public Liability Insurance] >= today then "Yes"

Else null

[Samarth_18 · Accepted solution]

Hi @HenryJS ,

Try below code:-

if [combined insurances] >= DateTime.LocalNow() 
then "Yes"
else if [Professional Indemnity Insurance] >= DateTime.LocalNow() and [Public Liability Insurance] >= DateTime.LocalNow() 
then "Yes"
else null

Thanks,

Samarth