Forum Discussion
Helper ICheck 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 <=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
Hi torsten_FO
let aux_ = Date.Day(DateTime.LocalNow()) -10 MyDay = if aux_ <= 0 then 1 else aux_ in MyDayor 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 MyDayPlease 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
1 Reply
- AlB
Community Champion
Hi torsten_FO
let aux_ = Date.Day(DateTime.LocalNow()) -10 MyDay = if aux_ <= 0 then 1 else aux_ in MyDayor 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 MyDayPlease 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