topic Re: Dax Help in DAX Commands and Tips

Dax Help

venal — Tue, 26 May 2020 05:16:39 GMT

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.

venal.

Re: Dax Help

Anonymous — Tue, 26 May 2020 05:34:30 GMT

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)

Re: Dax Help

venal — Tue, 26 May 2020 05:52:01 GMT

Anonymous

Thank you for the reply.

I will check and revert.