Any DAX to compare system time with latest 3 week numbers and preselect it?

[deb_power123]

Hi All,

Is there any available settings or way to handle preselection of the checkboxes in PowerBI?

I want the latest WeekNumbers to be always preselected in my visualization. Weeknumber should correspond to the system date.

Is there a way to achieve this ,may be using DAX?

The one pointed in blue arrow represents the latest 3 week numbers which I want to be preselected should always correspond to the system time. We are at present in week number 20 so the latest three weeknumber is Week17,Week18 and Week 20 so these three values should be preselected in the filter of the visualization.

Is it possible ? if so then how?

(I have used this DAX to calculate the weeknumber)

WeekNumber = WEEKNUM([Date]),21)

Expected output:

Input data :

Date	Location	%attendance
01.12.2020	B1	70
01.12.2020	B1	20
01.12.2020	B1	61
02.12.2020	B2	30
01.05.2021	B3	29
01.05.2021	B3	80
03.05.2021	B3	22
04.05.2021	B4	20
18.05.2021	B5	61
19.05.2021	B1	30
20.05.2021	B2	29
21.05.2021	B3	80
22.05.2021	B4	54
23.05.2021	B4	38

Kind regards

Sameer

[mahoneypat]

This article has several version of Date tables that all include a column called WeeksFromNow that you could use to filter any of your visuals where WeeksFromNow <=0 and WeeksFromNow>= -3.

No Sort Date Tables! – Hoosier BI

Pat