Hi everyone,
I am new to QS and am trying to prepare my data so that I can create visualizations.
In Excel I would use formula to convert a financial year to a date so that I can calculate between dates. For example the source data would show "FY 2015/2016" and I want to add a column in the data to convert it into "30/06/2016" as a date (then I can calculate age using DOB). Is there any function in QS that I can use to do it? Or if it's more convenient to do a "master dimension" I'll also be interested to know how.
Thanks very much in advance for any help!
