Simple Measure to always show current weeks data

[NBSheff]

Hi All,

I'm new to PBI and I've not been able to find the answer I want. It seems fairly straightforward but everything seems to be a variation of.

I would just like to create a 100% stacked visual, that filters on whatever the current week number is. I believe I can use a measure to create this filter?

I have created a calendar table in Excel that uses ISOWEEKNUM to generate the week number. My table looks like this:

Thanks in advance for your help!

[NBSheff]

Ah actually not quite, it returns the week number for all years, not just current year.

[v-rzhou-msft · Accepted solution]

Hi @NBSheff ,

I think you can try code as below to create a new calculated column and filter on True.

Current Year Week =
YEAR ( [Date] ) * 100
    + WEEKNUM ( [Date], 2 )
    = YEAR ( TODAY () ) * 100
        + WEEKNUM ( TODAY (), 2 )

Best Regards,
Rico Zhou

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

[NBSheff]

I think I have found the solution I was after. I created a new column on my Date Table and used:

Current Week = WEEKNUM([Date],2) = WEEKNUM(TODAY(),2)

Which returned a TRUE/FALSE value. I can now filter on True.