I have a table like below.
I want show only upcoming milestone based on current date.
For example, My canvas should show only RC2 Content Complete Oct/25/2024
Any ideas?
Hi @Rajakumar Burra ,
I would create a parameter and initialize it with the date of the upcoming milestone using a logical SQL query: select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE and Milestones IS NOT NULL
select MIN(Date) from
<Dataset/Subject area>
where Date >= CURRENT_DATE and Milestones IS NOT NULL
Then you can add an expression filter to your table (or to your canvas): Date = @parameter(<NAME>)(<DEFAULT>)
Date = @parameter(
<NAME>
)(
<DEFAULT>
)
Thanks @Federico Venturin It works.
In
I have not used Logical SQL parameter select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE
where Date >= CURRENT_DATE
and used Initial Value as "First Available" and bind to table filters.
