Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |