Adding Set expression to Dimension in table

[VaishnaviMogal2]

Hi,

I have a straight table containing 3 dimension columns like date, new parameter and missing parameter.

i want to display data of it for next 7 days of selected date for that i am using set expresssion

 {<[Start Datetime]={$(=chr(39)&Concat(Date(ValueLoop([Start Datetime],[Start Datetime]+7)),chr(39)&','&chr(39))&chr(39))}>}

but this set expression is not working to any field mentioned. i have tried using Aggr, only, maxString functions but nothing giving result.

how can i use this with dimension fields mentioned. any suggestion would be helpful

Thank you.

[TauseefKhan]

Hi @VaishnaviMogal2,
Check with this:

LET vSelectedDate = Date('2024-06-01'); // Example selected date for illustration

// Calculate max date which is 7 days ahead
LET vMaxDate = Date(Date#($(vSelectedDate), 'YYYY-MM-DD') + 7, 'YYYY-MM-DD');

// Define the date range for filtering
SET vDateRange = '>=' & chr(39) & Date(Date#($(vSelectedDate), 'YYYY-MM-DD'), 'YYYY-MM-DD') & chr(39) & '<=' & chr(39) & $(vMaxDate) & chr(39);

//Use this range in your set expression
Only({< [Start Datetime]={"$(vDateRange)"} >} [New Parameter])

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***