I have a data file, that contains daily records of transactions, I want to insert a column and lookup the date from lets say Column A, and return our filscal year. Then run that function down the 4000 or so rows.
Column A = 01/08/2019
Comumn B = Data
Comumn C = Data
Column D New Column - return a value of 2020-21
I want to do this in Power BI with a DAX function I guess