Forum Discussion

torsten_FO's avatar
torsten_FO
Icon for Helper I rankHelper I
5 years ago
Solved

Check value of 0 in Power Editor

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...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    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 

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

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