how to filter the current week in powerbi

[ayami123]

I wants to filter some values, but only weekly result
and I can't seem to find the current week filter in power bi.

[v-jiascu-msft]

Hi @ayami123,

If you already have a date table or a date column, you could add a calculate column of week number. Then you can filter the data with week number. 

WeekNum =
WEEKNUM ( 'Table'[Date], 2 )

Or you could create a date table, then create relationship with the current table. 

Calendar =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ),
    "WeekNUm", WEEKNUM ( [Date], 2 )
)

Best Regards!

Dale

[v-jiascu-msft]

Hi @ayami123,

Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.

Best Regards!
Dale