Forum Discussion
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 around this??
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.
2 Replies
- amitchandak
Super User
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=czNHt7UXIe8You can compare text with text and int with int
you can compare like
[Int col] & "" = [Text Colum]
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.
