How to pass date parameter through MYSQL query

Hi vacuesta 

As tested, it is possible on my side.

I test with SQL Server database, i create code in Advanced editor as below.

let
    Source = 
    if Parameter1="previous month"
    then 
       let
          Source1 = Sql.Database("WS-maggiel-02", "power bi test", [Query="select * from ss where DATEPART(m, [date]) = DATEPART(m, DATEADD(m, -1, getdate()))#(lf)AND DATEPART(yyyy, [date]) = DATEPART(yyyy, DATEADD(m, -1, getdate()))"])
       in
          Source1
    else
       if Parameter1="previous quarter" 
       then let
              Source2 = Sql.Database("WS-maggiel-02", "power bi test", [Query="select * from ss where DATEPART(q, [date]) = DATEPART(q, DATEADD(q, -1, getdate()))#(lf)AND DATEPART(yyyy, [date]) = DATEPART(yyyy, DATEADD(q, -1, getdate()))"])
            in
              Source2
        else 
            let
               Source3 = Sql.Database("WS-maggiel-02", "power bi test", [Query="select * from ss"])
            in
               Source3
in
    Source

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.