aaronismlb1
New Member
All,
Please let me know if there is a simple solution to accomplish the ability to simply reference a cell and output something based on it, using cube functions. As stated above by others I must be able to do this in the worksheet or I am going to punt and use xlookup... FYI i dont mind writing a measure and using it to get it done!
Example: *In Columns
Desired Result: List of account numbers and just want to drag down the formula
Account Number Account Description
100-04000-000 Shop Expense
100-05000-000 Shup Supplies
Problem Example:
Account Number Account Description
100-04000-000 =cubevalue("Inthisworkbook","what ever i need to do to avoid going to xlookup or any change to the date model itself ect....")
100-05000-000 ""
Please let me know if there is a simple solution to accomplish the ability to simply reference a cell and output something based on it, using cube functions. As stated above by others I must be able to do this in the worksheet or I am going to punt and use xlookup... FYI i dont mind writing a measure and using it to get it done!
Example: *In Columns
Desired Result: List of account numbers and just want to drag down the formula
Account Number Account Description
100-04000-000 Shop Expense
100-05000-000 Shup Supplies
Problem Example:
Account Number Account Description
100-04000-000 =cubevalue("Inthisworkbook","what ever i need to do to avoid going to xlookup or any change to the date model itself ect....")
100-05000-000 ""