Forum Discussion
Solved
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 b...
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.
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.
