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 "w...
  • 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)

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.