Make timestamp from a fiscal month and fiscal year

[Anonymous]

Hi,

Our GL database has a Fiscal Month and Fiscal Year field (both integers) but not date field.  In order to make time logic formulas easier, I want to create a timestamp using 1 as the day.  (example:  Fiscal year = 2015, Fiscal Month equals 7, so I would add a custom column in query editor that would create a time stamp of 2015-07-01 that I could then use for timeintelligence functions.

I am fairly new to Power BI Desktop so how would I create a timestamp using a fiscal year field, fiscal month field, and a 1 for the day?  (and defaul to 12:00:00 AM for time so it matches my BasicCalendar database).

Thank you very much for any help with this...

[austinsense · Accepted solution]

I think a calculated column (DAX) like this ...

=DATE(Table[Fiscal Year], Table[Fiscal Month],1)

Here's the link to the DAX documentation (LINK)

Or as a custom column (M) inside the query ...

=Date.FromText(Table[Fiscal Year] & Table[Fiscal Month] & "01")

Here's the link to the M documentation (LINK)

[Anonymous]

This worked - thanks!