Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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??
Solved! Go to 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.
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 , 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]