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 @amitchandak ,
I am following your youtube tutorial (https://www.youtube.com/watch?v=q_Ke80KNcEw) to create the RY week no. I noticed that
The formula I have written for FY week is as follow:
@Dunner2020 , I checked it. It because of FY. I have used Endofyear for FY end date. And Using today as the end date. As Endofyear do not go beyond the calendar date. So for last year, FY end date is incorrect and it was creating the wrong end date.
I correct calendar like
Date = CALENDAR(date(2013,04,01),date(2021,03,01))
OR you can create an FY like, Based your need
If(month([Date])<=3, year([Date]) -1, Year([Date])) // This can any month
@amitchandak , Thanks for the clarification. I generated the RY Year the way you mentioned in your reply and it fixed the problem.However, I noticed that Week Rank is producing value upto 367. The formula is used for Week Rank is
Hi @Dunner2020,
It should work as a general weeknum function to return the correct week number if you are working with a common calendar table and filtered based on the year field.
RW =
RANKX (
FILTER ( 'Table', YEAR ( [Date] ) = YEAR ( EARLIER ( 'Table'[Date] ) ) ),
[Week start],
,
ASC,
DENSE
)
Since your table needs to calculated based on the fiscal fields. If RYear field does not work well with the above expression, I think you may need to add offset to modify these fiscal fields to make them work as common calendar fields.
Regards,
Xiaoxin Sheng
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |