Forum Discussion

mazwro's avatar
mazwro
Helper II
2 years ago
Solved

Date formula - need to replicate sql

I have a two tables - one takes source direcly from SQL, and I am adding another formated in Power bi and I need to apply the same filters. And here is where my issues start

 

The SQL has it like this:

 

 

WHERE MONTH(date_order) = MONTH(CURRENT_DATE())#(lf)AND YEAR(date_order) = YEAR(CURRENT_DATE())

 

 

 

The table I have in sql comes from a different place so I need to apply this in power BI.

I created a custom column and I want to filter values 1 later:

 

 

if Date.Month([date_of_order]) = Date.Month(Date.From(DateTime.LocalNow())) 
&
Date.Year([date_of_order]) = Date.Year(Date.From(DateTime.LocalNow()))
then  "1" else"0"

 

 

But this gives me an error which I do not understand:

Any ideas how to fix it?

 

  • Try the below code.

     

    if Date.Month([date_of_order]) = Date.Month(Date.From(DateTime.LocalNow())) 
    and 
    Date.Year([date_of_order]) = Date.Year(Date.From(DateTime.LocalNow()))
    then  "1" else"0"

2 Replies

  • Try the below code.

     

    if Date.Month([date_of_order]) = Date.Month(Date.From(DateTime.LocalNow())) 
    and 
    Date.Year([date_of_order]) = Date.Year(Date.From(DateTime.LocalNow()))
    then  "1" else"0"
    • mazwro's avatar
      mazwro
      Helper II

      This worked, so seems power query does not like & signs. Thanks