Skip to main content

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

 

Hi Mohan,

I would begin by adding a property to your transaction list that maps each row to the Week dimension, like this:

Then, in the week dimension, the following formula should work:

 

I hope that helps!

(Side note: I think you could probably use integer format, rather than number, for this)


Hi William, 

It means that I have to create a new dimension “Week Dimension” before adding this property to the calendar weeks transaction list?

The week dimension property you created is using Week as Dimension or a new dimension has to be created?

 

 

I end up retrieving the Week numbers “1-2019” instead of “WC-2019-01-07”. 

 

Thanks for your help


Reply