Assistance on DAX

[lavankumar1989a]

Hi Experts,

Greetings for the day and hope all are doing good!

Need your kind assistance on achiving my requirements. i have date column and when user selected a perticular date in page 1, user have to see results in page 2 and page 3 like that day to next 6 days. 

for example,

if user selected date as 13th Jun'2021 in first page....

user can see results in page 2 and page 3...form seleted date to till selected date+6 which means can see data 13th Jun'2021 to 19th Jun'2021

Thanks in advance for your help.

Thanks,

Lavan

[v-kkf-msft · Accepted solution]

Hi @lavankumar1989a ,

If you want to filter multiple visuals in this way, I think it is more convenient to create a direct correspondence between the date of the slicer and the date to be filtered. Try the following cade in Power Query:

let
    Source = Table.FromValue(#"Table"[Date], [DefaultColumnName = "Slicer_Date"]),
    #"Removed Duplicates" = Table.Distinct(Source),
    #"Added Custom" = Table.AddColumn(#"Removed Duplicates", "Table_Date", each List.Dates([Slicer_Date],7,#duration(1,0,0,0))),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Table_Date")
in
    #"Expanded Custom"

Then create * : * relationship between Table and Slicer table.

Add Slicer_Date column to the slicer on page1, and synchronize slicer to other pages.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lavankumar1989a]

Thanks much @v-kkf-msft, solution which you provided meets my requirement and i need one more help that is,

if i select a date from slicer table like 06/01/2021, all the remaining visuals has to show data for next 7 days 

So kindly sugest to achive it. Thanks in advance for your kind support and help.

Thanks,

Lavan

[v-kkf-msft]

Hi @lavankumar1989a ，

You only need to create relationships between Table and other tables.

Best Regards,
Winniz