Forum Discussion
New Column Value Based on Date Range
I am trying add a new column for the "Year", based on a date range with a specified Start Date and End Date. Some of the problems I am running into: The "Year" has an unconventional Start and...
BradleyH , seem like you want to create FY
FY = if( Month(([DAte])) <5 , year(([DAte]))-1 ,year(([DAte])))
Also refer
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1