Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @Kbrennan856,
You can use below formula to get Week Number from Saturday to Friday.
Calculate column formula:
weeknum = VAR _calendar = FILTER ( ADDCOLUMNS ( 'Calendar', "WeekDay", WEEKDAY ( [Date], 1 ) ), YEAR ( [Date] ) = YEAR ( EARLIER ( [Date] ) ) ) RETURN COUNTROWS ( FILTER ( _calendar, [Date] <= EARLIER ( [Date] ) && [WeekDay] = 7 ) ) + 1
Regards,
Xiaoxin Sheng
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
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,
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,
Hi @Kbrennan856,
I hope it helps you:
https://msdn.microsoft.com/en-us/library/mt260707.aspx
Thanks,
Ricardo