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.
A better way would be to create a calendar that incorporates financial periods as well as calendar dates. If you search here for master calendar and fiscal/financial period you will find a wealth of posts that will get you going.