Forum Discussion
FZOU
Helper IV
Helper IVUsing 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.
FZOUHelper IV
Helper IVamitchandak 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
Community Support
Community SupportHi 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.