Forum Discussion

lisaburton's avatar
lisaburton
Frequent Visitor
4 years ago
Solved

dax for week number

I want to show the current week only on a matrix of plan vs adherence. I can display all 52 weeks of the year but i am unsure of how to set up a Dax to only view the current week   
Tutorial Requests
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi lisaburton ,

    According to your description, here's my solution, create a measure.

    Check =
IF ( MAX ( 'Table'[Week No] ) = WEEKNUM ( TODAY () ), 1, 0 )

    Put the measure in the visual filter and select its value to 1.

    After apply filter, get the correct result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi lisaburton ,

According to your description, here's my solution, create a measure.

Check =
IF ( MAX ( 'Table'[Week No] ) = WEEKNUM ( TODAY () ), 1, 0 )

Put the measure in the visual filter and select its value to 1.

After apply filter, get the correct result.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

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