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 report show me wrong number of week by the calendar.
Why I have second week but in a paper calender is first week of year?
Can I fix this?
Thank you
Ondřej
Solved! Go to Solution.
@Fidzi8 , You have to create a customer week
like these columns in date table
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1 // or use WEEKDAY('Date'[Date],1) for Sunday week
min week start of year = minx(filter('Date',year([Week Start date])=earlier(year(Week Start date]))),[Week Start date])
week No = quotient(datediff([min week start of year],[date],day),7)+1
Week Start Year = minx(filter('Date',[Year] =earlier([Year])),[Week Start date])
There are a couple of issues logged on this in last week, as this does not match with other Microsoft calendar in other apps
possible to get the week number written most nicely?
how do i combine these two formulas?
This (the format i want)
Hi @Fidzi8 ,
Create a column as below:
weeknum1 =
var _firstday=CALCULATE(MIN('Table 2'[Date]),FILTER('Table 2',YEAR('Table 2'[Date])=YEAR(EARLIER('Table 2'[Date]))))
Return
IF(WEEKDAY(_firstday,2)<>1,WEEKNUM('Table 2'[Date],2)-1,WEEKNUM('Table 2'[Date]))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@Fidzi8 , You have to create a customer week
like these columns in date table
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1 // or use WEEKDAY('Date'[Date],1) for Sunday week
min week start of year = minx(filter('Date',year([Week Start date])=earlier(year(Week Start date]))),[Week Start date])
week No = quotient(datediff([min week start of year],[date],day),7)+1
Week Start Year = minx(filter('Date',[Year] =earlier([Year])),[Week Start date])
There are a couple of issues logged on this in last week, as this does not match with other Microsoft calendar in other apps
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |