Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |