Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
4 years ago
Solved

Power Query Column IF Statement

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]...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

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