Generating Calendar Date Out of Fiscal Year and Month

[Anonymous]

How can I create calendar date (using the first date of each month) out of fiscal year and month?

For example, I would like the create the date column out of the first two columns?

[Tanushree_Kapse]

Hi @Anonymous ,

Follow the below steps:

1. Go to Edit Query/ Transform Data
2. Right click on the first column; Select option- Split using Delimiter.
    Specify the Delimiter "-"
3. You would get two seperate columns of Year. We'll use the one from whcih you need the year.
4. Now, in the same way split the other column using delimiter.
5. Name the seperated column as Month.
6. Now, Close and Apply.
7. In the Data View model: Add a new column in the table:
    DAX:  Date= FORMAT(DATE(YEAR(Table(Year), MONTH(Table(Month)), "01"), "mm/dd/yyyy")

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks

[Anonymous]

Thanks for the response.

But, I need to convert using both years as this is a financial year. For the months Jul-Aug-Sep-Oct-Nov-Dec, the year will be the first year and for the months Jan-Feb-Mar-Apr-May-Jun, the year will be the second year. 

See the row for January and February below-

Appreciate the help!