Dax Help

[venal]

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.

[harshnathani · Accepted solution]

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]

@harshnathani 

Thank you for the reply.

I will check and revert.