Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Lookupvalue for both Integer and text

Hi Experts   is is possible to lookup a value from a other table where the expected result is a text based on a date.  Lookupvalue(ControlTab[Month],Control[text], Input[month])   what's the way...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    According to my understanding, you want to get ControlTab[Month] via LOOKUPVALUE() ,but the datetype of searched columns are different ( Control[text] is String,  Input[month] is Int ), right?

    You could use     DATE() to change the Input[month] to Date type and use FORMAT() to get MonthName like this:

    Column =
LOOKUPVALUE (
    Control[Month],
    Control[Text], FORMAT ( DATE ( 2021, 'Input'[Month], 1 ), "MMMM" )
)

    The final output is shown below:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

According to my understanding, you want to get ControlTab[Month] via LOOKUPVALUE() ,but the datetype of searched columns are different ( Control[text] is String,  Input[month] is Int ), right?

You could use DATE() to change the Input[month] to Date type and use FORMAT() to get MonthName like this:

Column =
LOOKUPVALUE (
    Control[Month],
    Control[Text], FORMAT ( DATE ( 2021, 'Input'[Month], 1 ), "MMMM" )
)

The final output is shown below:

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.