Hello all,
I have a table in PowerPivot that is linked to a table from an Access database. I have a [ReportingMonth] field in MMMM format and a [ReportingYear] field in YYYY format. I'm looking for a way to combine the two fields into a [ReportingDate] field in MM/DD/YYYY format so that I can create a relationship with my Date Table. All of my reporting is by month, quarter and year so the day doesn't really matter. As I was trying to work this out myself I started with a simple =Month([Reporting Month]) formula, but I get an error stating, "Calculation error...:Cannot convert value 'September' of type Text to type Date. However, the data type for the calculated column is currently set as Auto (Whole Number).
Does anyone have a solve for this?
Thanks in advance.
Bookmarks