cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smjzahid
Helper IV
Helper IV

How to use Datediff in power query

I want to create a conditional or a custom column within Power Query (using M) and NOT DAX, Here is my requirement

 

if [Consent Application Submitted] is not blank and [Consent Application Submitted] > 6 Weeks from today then "White"

 

if [Consent Application Submitted] is not blank and [Consent Application Submitted] < 6 Weeks from today then "Red"

 

I know I can do this using DAX (DATEDIFF). However, I want to create a column using Power Query. 

 

Is there a way to achieve this in Power Query or the M code. 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @smjzahid ,

 

You could refer to the following codes:

if
Duration.Days(Date.From(DateTime.LocalNow())-[Date])>42
then "White"
else "Red"

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
v-eachen-msft
Community Support
Community Support

Hi @smjzahid ,

 

You could refer to the following codes:

if
Duration.Days(Date.From(DateTime.LocalNow())-[Date])>42
then "White"
else "Red"

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
camargos88
Community Champion
Community Champion

Hi @smjzahid ,

 

Try this one:

 

if [Date] > Date.AddWeeks(Date.From(DateTime.LocalNow()), 6) then
"White"
else
"Red"

 

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors