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
How to calculate fiscal week in calender in power query not in tble view , Week start day should be Monday and Fiscal month is Octomber
Please help me
Solved! Go to Solution.
You can add a custom column in the query editor and put this formula in the pop-up box. Replace [Date] with [YourDateColumnName] if needed.
let
FY = if Date.Month([Date]) < 10 then Date.Year([Date]) -1 else Date.Year([Date]),
FirstMonday = List.Select(List.Transform({0..6}, each Date.AddDays(#date(FY, 10,1),_)), each Date.DayOfWeekName(_) = "Monday"){0}
in
Number.RoundUp((1+Duration.TotalDays([Date] - FirstMonday))/7,0)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can add a custom column in the query editor and put this formula in the pop-up box. Replace [Date] with [YourDateColumnName] if needed.
let
FY = if Date.Month([Date]) < 10 then Date.Year([Date]) -1 else Date.Year([Date]),
FirstMonday = List.Select(List.Transform({0..6}, each Date.AddDays(#date(FY, 10,1),_)), each Date.DayOfWeekName(_) = "Monday"){0}
in
Number.RoundUp((1+Duration.TotalDays([Date] - FirstMonday))/7,0)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you Sir
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |