Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an excel spreadsheet with 3 individual dates in three separate columns: Budget Date, Forecast Date, Execution Date.
If one exists, the others are null.
I need to concatenate these three date fields in the load editor then run the [autoCalendar] script breaking them out into quarters, years, etc...
Running the script as-is I get three dates with the autocalendar, I need them to be combined into one so my pivot table will work properly.
Thank you for the help.
Create a new Date column by using Alt
Date(Alt([Budget Date], [Forecast Date], [Execution Date])) as CalendarDate
Thanks
Celambarasan
Create a new Date column by using Alt
Date(Alt([Budget Date], [Forecast Date], [Execution Date])) as CalendarDate
Thanks
Celambarasan