topic Simple Measure to always show current weeks data in DAX Commands and Tips

Simple Measure to always show current weeks data

Anonymous — Fri, 23 Jun 2023 13:54:04 GMT

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!

Re: Simple Measure to always show current weeks data

Anonymous — Fri, 23 Jun 2023 14:19:59 GMT

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.

Re: Simple Measure to always show current weeks data

Anonymous — Fri, 23 Jun 2023 14:25:11 GMT

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

Re: Simple Measure to always show current weeks data

Anonymous — Mon, 26 Jun 2023 07:33:35 GMT

Hi Anonymous ,

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.