How to countrows with filter weeknum of yearnum

[Nhphong]

Hello,

I had trouble with dax function while trying to get data with 2 filters. There are This week and last week of year 2023.

Currently, i have dax function that can get data

Last week: Calculate(Countrows'Table'),Filter('Table',[Weeknum]=Max[weeknum] -1)

This week: Calculate(Countrows'Table'),Filter('Table',[Weeknum]=Max[weeknum])

Everything is fine until data passed to 2023, my Max[weeknum] isn't correct anymore because the Max[weeknum] is on 2022.

Tried dax function: Calculate(Countrows'Table'),Filter('Table',[Weeknum]=Max[weeknum] && [Year]=2023) but it returns blank value.

Thanks & Regards,

Hoai Phong

[Ahmedx]

You need to create a column in the calendar table
WEEK Order =DATEDIFF(TODAY(),[Date],WEEK))
 
further like this
This week = CALCULATE([Value sum],'Calendar'[WEEK Order]=0)
Last week = CALCULATE([Value sum],'Calendar'[WEEK Order]=-1)

[Nhphong]

Hi,

Thank you for reply. But i still can't figure how to use DATEDIFF to solve my problem.

I want to countrows with 2 filters. There are 2023 in year column and maximum weeknum of 2023.

Thanks & Regards,

Hoai Phong