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
Kbrennan856's avatar
Kbrennan856
Frequent Visitor
8 years ago

Hi,

 

thanks for your reply, here is an example of what i need

 

i have a date column ie 2018-02-16

and i need another column with the week number. My week no should be 7 as i use saturday as frist day of the week but dax will return me 6

Thyago_Rezende's avatar
Thyago_Rezende
Icon for Resolver I rankResolver I
8 years ago

Hi,

 

You can include one column with weekday_name, then to do the SWITCH function based on the weekday_name. 

 

I hope it helps you.

Best regards,