Check value of 0 in Power Editor

[torsten_FO]

Hi,

i use this Query in M for Date-modifying:

let
    MyDay = Date.Day(DateTime.LocalNow()) - 10
in
    MyDay

My question here is how can i validate that the value in MyDay is not <=0 ?

Example: The Date is 26.10.2020. When i substract 10 the value is 16.  But when the Date is 06.10.2020 and i substract 10 the value must not be -04.  In this case e need the value 01.

How can i check this with an if-statement?

regards

Torsten

[AlB · Accepted solution]

Hi @torsten_FO 

let
    aux_ = Date.Day(DateTime.LocalNow()) -10 
    MyDay =  if aux_ <= 0 then 1 else aux_
in
    MyDay

or if you want it in just one line:

let
    MyDay =  if (Date.Day(DateTime.LocalNow()) -10) <= 0 then 1 else Date.Day(DateTime.LocalNow())-10
in
    MyDay

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers