Forum Discussion
rhborders
Helper I
Helper ILooking up multiple values
Hello, In our database we have a schema that tells us what date we get an invoice and then another dates schema that converts calender days into a fiscal day of year. For example if we got an in...
You can use lookupvalue function to make it happen.
Let me know if you need further assistance on this function
parry2k
Super User
Super Userso you want date differenece to calculated days between cal_date and fiscal_year_begin_date??
rhbordersHelper I
Helper INo, what I want is to use the fical mean value and look that up in the fiscal day of year column and return the calendar date.
- parry2k
got it.
Is "Fiscal Mean" a column or measure?
Is there relationship between date and other table?
- rhborders
Fiscal Mean is a calculated column and there is not a direct relationship between the two
- parry2k
You can use lookupvalue function to make it happen.
Let me know if you need further assistance on this function