Days function in Power Query

Hi all,

Is there a way i can create fuction like below in Power Query please.

=IF(DAYS360([@[Posting start date]],[@[Posting End date]])<0,"",DAYS360([@[Posting start date]],[@[Posting End date]]))

for example i encloased a file and the output i needed it is in the column "S".

Thanks & regards,
Hudson.

Hi Marvin,

Thanks for looking into my query, is there a way i can also remove Negative values , for example if my start date is bigger than my end date sometimes i get to see the -Negv values. do you want to also advice in that please.

Hi ,

This worked like a charm and thanks for taking a look at it .

May i ask some tweeks in here please , is there a way i can Handle errors , if eithers of the dates are null it is showing Error in my output .. can we fix this ?

Thanks Mate . all good now