Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Error with LOOKUPVALUE

Hey everyone!   I have two tables. The first one looks like this: Count (Float Type) MonthInCalendar ( Date Type) 11016.26 mar. 2021 22750.6 apr. 2021 24028.95 may. 2021 26069.2...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    Please try this code to do that.

    Column = 
LOOKUPVALUE (
    Table1[Count (Float Type)],
    Table1[MonthInCalendar (String Type)], FORMAT ( 'Table2'[Date (Date type)], "mmm. yyyy" )
)

     

    Result:

     

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Please try this code to do that.

Column = 
LOOKUPVALUE (
    Table1[Count (Float Type)],
    Table1[MonthInCalendar (String Type)], FORMAT ( 'Table2'[Date (Date type)], "mmm. yyyy" )
)

 

Result:

 

 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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