Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
torsten_FO
Helper I
Helper I

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 <=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

1 ACCEPTED SOLUTION
AlB
Super User
Super User

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 

 

SU18_powerbi_badge

View solution in original post

1 REPLY 1
AlB
Super User
Super User

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 

 

SU18_powerbi_badge

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors