Forum Discussion
Solved
Looking 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
No, 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.
got it.
Is "Fiscal Mean" a column or measure?
Is there relationship between date and other table?
Fiscal Mean is a calculated column and there is not a direct relationship between the two
You can use lookupvalue function to make it happen.
Let me know if you need further assistance on this function
I had tried this before and only got partial results. Some of my records are blank when all should be full. I reran and had the same issue. Any idea as to why this may be?