Forum Discussion

noliverte's avatar
noliverte
Icon for Helper III rankHelper III
5 years ago
Solved

filter table by year and weekyear

Hello,   I'd like to create simple filters using a dax measure... I usually use calculated fonction...   CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])   But I just have dates and t...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi noliverte ,

    When I reply you the current week is 51, so you want to show data about text 50 right?

    You can create a measure like this, put it in the table visual filter and set its value as 1:

    A = 
IF (
    WEEKNUM ( TODAY (), 2 ) - 1
        = WEEKNUM ( SELECTEDVALUE ( 'Table'[Date] ), 2 ),
    1,
    0
)

    Attached the sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

noliverte , this should give you a new table as weeknumber is in date table

 

new table = CALCULATETABLE(Table,filter(Date,date[week_year_no]=WEEKNUM(TODAY())))

 

new measure = CALCULATE(countrows(Table),filter(Date,date[week_year_no]=WEEKNUM(TODAY())))

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

  • noliverte's avatar
    noliverte
    Icon for Helper III rankHelper III
    5 years ago

    Hi amitchandak,

     

    Thanks for taking time to respond to me,

    I changed my table like this

    If I use

    new measure = CALCULATE(countrows(Explications),filter(Calendrier,Calendrier[Week-num]=WEEKNUM(TODAY())-1))

     

    I don't have "text week50"...

    If I change in the visualization menu, I can't have only "text week50"

    Do you have an idea ?

     

    Have a nice day

     

    Noliverte