Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RichOB
Post Patron
Post Patron

Finanical Year Quarter DAX

‎06-23-2025 12:40 AM

Hi, I have a financial spreadsheet and I need two new date-based columns, please. I need some help to get DAX for the FinancialYearQuarter and the FinancialYearMonth that I've put as an example in the green font.   

 

DateMonthFinancial_MonthFinancial_QuarterFinancial_YearFinancialYearMonthFinancialYearQuarter
01/10/2024October7Q320242024,72024, Q3
01/11/2024November8Q320242024,82024, Q3
01/12/2024December9Q320242024,92024, Q3
01/01/2025January10Q420242024,102024, Q4
01/02/2025February11Q420242024,112024, Q4
01/03/2025March12Q420242024,122024, Q4
01/04/2024April1Q120252025,12025, Q1

 

Thanks

Labels:
Message 1 of 2
131 Views
0
1 ACCEPTED SOLUTION
Demert
Resolver III
Resolver III

‎06-23-2025 12:53 AM

Hi you can create these new column by the following dax code:

Demert_0-1750665270212.png

 

FinancialYearMonth = Table[Financial_Year] & "," & Table[Financial_Month]
FinancialYearQuarter = Table[Financial_Year] & ", " & Table[Financial_Quarter]

View solution in original post

Message 2 of 2
123 Views
0
1 REPLY 1
Demert
Resolver III
Resolver III

‎06-23-2025 12:53 AM

Hi you can create these new column by the following dax code:

Demert_0-1750665270212.png

 

FinancialYearMonth = Table[Financial_Year] & "," & Table[Financial_Month]
FinancialYearQuarter = Table[Financial_Year] & ", " & Table[Financial_Quarter]
Message 2 of 2
124 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All