Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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