topic Re: Dynamic parameter selection for due days in DAX Commands and Tips

Dynamic parameter selection for due days

nish18_1990 — Mon, 16 Jun 2025 09:52:42 GMT

Hi ,

I need a parameter on days selection . If i select Closure in the next 10 calendar days . It should show me the category where the closure date is in next 10 calendar days .

"X" mentioned below would a parameter with dynamic value . Whatever user input there it should show data accordingly .

Closure in the next X calendar days

This is my data

Category	Sub Category	Sales	Quantity Q2	country	Closure date
Furniture	Chairs	100	10	China	22/07/2025
Furniture	Tables	100	20	China	23/08/2025
Automobile	Cars	100	30	China	21/7/2025
Automobile	Bikes	700	40	China	21/6/2025
Furniture	Chairs	100	13	India	21/8/2025
Furniture	Tables	500	22	India	21/9/2025

Thanks

Re: Dynamic parameter selection for due days

johnt75 — Mon, 16 Jun 2025 10:07:13 GMT

Create a numeric parameter ranging from 1 to the maximum number of days you want to be able to filter for. Then create a measure like

Closure date within X days = VAR ChosenDays = [Num Days Value] VAR RefDate = SELECTEDVALUE ( 'Table'[Closure Date] ) VAR DaysDiff = DATEDIFF ( TODAY (), RefDate, DAY ) VAR Result = IF ( DaysDiff <= ChosenDays, 1 ) RETURN Result

Add that measure as a filter to your table or matrix visual, set to show only when the value is 1.

Re: Dynamic parameter selection for due days

nish18_1990 — Mon, 16 Jun 2025 11:52:32 GMT

Could you please attach the power bi file for reference

Re: Dynamic parameter selection for due days

nish18_1990 — Mon, 16 Jun 2025 13:08:43 GMT

Sorry i did tried it but its not working . I am getting 1 value even if i select any number on parameter . I need like if i select 20 on parameter . It should show categories having closure date in next 20 days from today .

Re: Dynamic parameter selection for due days

johnt75 — Mon, 16 Jun 2025 13:42:31 GMT

Here you go

Re: Dynamic parameter selection for due days

v-echaithra — Mon, 16 Jun 2025 14:14:47 GMT

Hi nish18_1990 ,

Please look into the file attatched below.

Re: Dynamic parameter selection for due days

v-echaithra — Mon, 16 Jun 2025 14:12:23 GMT

Hi @nish18_1990 ,

Thanks for the update, please look into the below pbix file.

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,
Chaithra E.

Re: Dynamic parameter selection for due days

v-echaithra — Thu, 19 Jun 2025 08:03:27 GMT

Hi nish18_1990 ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

Re: Dynamic parameter selection for due days

nish18_1990 — Thu, 19 Jun 2025 12:31:51 GMT

Its not working if i select any numbers , its showing same date .

Re: Dynamic parameter selection for due days

nish18_1990 — Mon, 23 Jun 2025 08:22:42 GMT

This calculation worked but i need to change it a bit as it will give past dates than today as well. I included >today in and condition for Var Result.