Forum Discussion
Post ProdigyDate Filter on paginated report
Hello,
Is it possible to also create a filter in a paginated report as a relative date?
Hi Frixel ,
Regarding your question, you can only set fixed dates in paginated reports.
If you only want to display data for the current day, you can create a custom column in Power Query that displays 'YES' for current day data and 'NO' otherwise.
if Date.IsInCurrentDay([Date]) = true then "YES" else "NO"Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Frixel ,
Regarding your question, you can only set fixed dates in paginated reports.
If you only want to display data for the current day, you can create a custom column in Power Query that displays 'YES' for current day data and 'NO' otherwise.
if Date.IsInCurrentDay([Date]) = true then "YES" else "NO"Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.