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.

     

lisaburton's avatar
lisaburton
Frequent Visitor
4 years ago

Thank you!

lisaburton's avatar
lisaburton
Frequent Visitor
3 years ago

I have a 'last week' dax and i can amend this to show the 'next week' date but how do i amend it to show this week date? 

Last Week =
IF (
YEAR ( [Week ] ) = YEAR ( TODAY () )
&& WEEKNUM ( [Week ],2 ) = WEEKNUM ( TODAY () -7 ),
"Yes",
"No"
)