How to filter data based on current year, month and week

[A_Jafery]

Hi guys,

I want to make a filter based on period which are weekly, monthly and annual as show in png.

Date(Date) as [A Date],
WeekDay(Date) as [A Weekday],
Week(Date) as [A Week],
'Week'&Ceil(Day(Date)/7) as [A MonthlyWeek],

[Gopi_E · Accepted solution]

create inline load for which you created fields then you can use that fields a filter

[A_Jafery]

Thank u.  I already made inline load and make filter thru expression

Period:
LOAD * Inline [
Period
Weekly
Monthly
YTD
];