Forum Discussion

Kbrennan856's avatar
Kbrennan856
Frequent Visitor
8 years ago

First Day of week

Hi,   My week runs Saturday to Friday,   is there a way in dax i can get the week no and year? as currently i only have the option in dax for Sunday to monday
Need Help
Thyago_Rezende's avatar
Thyago_Rezende
Icon for Resolver I rankResolver I
8 years ago

Hi Kbrennan856,

 

You can do the SWITCH function like below:

 

Weekday = 
SWITCH(
    TRUE();

    "Saturday"; 0 ;
    "Sunday"; 1 ;
    ...;

    "Friday"; 6 )

 

I hope it helps you.

Best regards,