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 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!

 

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.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • 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.