Concatenate & Convert Period and Year to Full Date
Summary
Looking to compare the currently selected Year-Period members with a date-typed Account dimension member.Content
Is it possible to concatenate and then convert a selected Year-Period intersection into a usable full date string inside of a Dynamic Calc member formula (ASO, Account Dimension)? For example, we have a need for the below result:
([Years].currentmember, [Period].currentmember, "01") = 20180501 (when May and FY18 are the currently selected member).
I have been working on this question for a while and cannot quite get to a full solution. I have tried a number of different methods pulled out the current Technical Reference but nothing seems to validate correctly. I know how to go the opposite direction (converting "20180501" into "May" and "FY18") but can't seem to translate the logic.