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.
amitchandak
Super User
Super UserFZOU One thing which may be a reason - Data type on the screen should Date ?
FZOUamitchandak 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
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.