Forum Discussion
Translate Dates into Custom Financial Quarters
I have a simple date column in a table in the format below: 10/10/2018 01/02/2017 04/02/2018 How can I arrange these by some custom financial quarter dates? Q1 Feb-20 May...
Did you use the following DAX to change get the number of Month?
Month = MONTH('US Calendar'[Date])
thats it! How does the logic work there? if I wanted to amend to change the dates to:
Q1 | Feb-04 | May-05 |
Q2 | May-06 | Aug-04 |
Q3 | Aug-05 | Nov-03 |
Q4 | Nov-04 | Feb-03 |