Lookupvalue for both Integer and text

[Anonymous]

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 around this??

[v-eqin-msft · Accepted solution]

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.

[amitchandak]

@Anonymous , for a column from other tables you need to deal with it bit differently.

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

You can compare text with text and int with int

you can compare like

[Int col] & "" = [Text Colum]