Using power query parameters

[FZOU]

Hi everyone,

I want to replace a static date by a power query parameter, i tried some tricks but without result i'm gonna explain it below .

Data source : tha static date it's marked in YELLOW below:

I created a power query parameter named LastDate you can see it below : 

Next i tried to replace the static date by this parameter like shown below :

The problem is the function #date("2021-04-30") should have 3 parameters instead of just one "LastDate" and if i add a blank #date(LastDate," "," ") it wont work it can't be converted to number !

Any one can help please ?

Thank you 🙂

[amitchandak]

@FZOU One thing which may be a reason - Data type on the screen should Date ?

[FZOU]

@amitchandak  Yes even when i change it to date it's same thing the #date function expects 3 arguments fro exp #date(arg1,arg2,arg3) but i have only one #date(LastDate,?,?)

[Icey · Accepted solution]

Hi @FZOU ,

Since the "LastDate" parameter's type is "Date", it is not needed to use #date() function. Try this:

...
{Cube.ApplyParameter, "[!V000001]",{LastDate}},
...

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.