Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Date Function - DAX - Create new column from an existing date column

Hi I'm trying to create following columns using DAX from an existing date column on a table. 1. Fiscal_year_numer : Output -> 2021-22   I've created a "year" column with DAX like below: Year = Y...
Date Function
DAX Commands
Help required
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

Fiscal years more often than not do not align with the usual calendar dates. If you have a functional rule that tells you how to create a fiscal value from the usual date, then you should code it appropriately (but the details are specific and without this knowledge nobody can give you formula). Fiscal calendars of any flavour (created in DAX or Power Query) can easily be found via a Google search. You can even start here -> www.sqlbi.com.