Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Simple Measure to always show current weeks data

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 ...
current week
current week filter
Show current week
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.