Forum Discussion

venal's avatar
venal
Icon for Memorable Member rankMemorable Member
6 years ago
Solved

Dax Help

Hello Folks,

 

I have a Data with the column names "Date and Num". I want only show the slicer value as "1,4,13,52" weeks. How to achieve this with the DAX (weeknum).

 

Note:- Currently i used "weeknum" dax function and created one more column as week, It is showing the week number from 1-52.But as per the requirement wanna show only 4 values in slicer visual.

 

Thank you in advance.

BR

venal.

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi venal ,

     

    You can create a calculate column in your date table.

     

    4 Week Nos =

    SWITCH(
    TRUE(),
    'Date'[Week Number] = 1 , 1,
    'Date'[Week Number] = 4, 4,
    'Date'[Week Number] = 13 , 13,
    'Date'[Week Number] = 52 , 52,
    BLank()
     
    )
     
     
    and in slicer visual
     
     
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi venal ,

     

    You can create a calculate column in your date table.

     

    4 Week Nos =

    SWITCH(
    TRUE(),
    'Date'[Week Number] = 1 , 1,
    'Date'[Week Number] = 4, 4,
    'Date'[Week Number] = 13 , 13,
    'Date'[Week Number] = 52 , 52,
    BLank()
     
    )
     
     
    and in slicer visual
     
     
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

    • venal's avatar
      venal
      Icon for Memorable Member rankMemorable Member
      6 years ago

      Anonymous 

      Thank you for the reply.

      I will check and revert.