Forum Discussion
Using power query parameters
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 🙂
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.
3 Replies
FZOU One thing which may be a reason - Data type on the screen should Date ?
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,?,?)
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.
