Hello,
I am trying to perform a vlookup function where I would like to retrieve a value from a transaction list and return to a dimension with same number format.
I want to extract the “Weeknum” from Transaction : Calendar Weeks based on unique property Calendar.Date and populate it in under the Week Dimension’s property “Weeknum” based on its unique property Start Date
Tried ITEM function but i get a lot of data type errors using this formula , ITEM('Calendar Weeks'.Weeknum,Week.'Start Date')
thanks