Converting Date and Time to Financial Year and Quarter/Month (Australian Date)
Hi All, I currently have a column (StartDate) that has values in the following format: DD/MM/YYYY HH:MM:SS AM/PM E.g. 14/08/2022 2:00:00 PM I was hoping to accomplish conversions through DAX commands but wasn't really sure how to approach it, New Column 1 (Month & Financial Year) 14/08/2022 2:00:00 PM --> Aug FY22 New Column 2 (Quarter and Financial Year) 14/08/2022 2:00:00 PM --> Q1 FY22 Any help or guidance would be appreciated!