Forum Discussion

nick9one1's avatar
nick9one1
Icon for Helper III rankHelper III
3 years ago
Solved

lookup boolean value from another table

I have two tables and using this DAX to import values from one table to the other; (this works) Total Rooms = CALCULATE( MAX('Lettings Fact_SPVDetails_Summary'[TotalRooms]), FILTER( ...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, nick9one1 

     

    I simulated some data to restore your problem, you can use the lookupvalue formula to see the boolean value.

    Total Rooms = 
LOOKUPVALUE (
    'Lettings Fact_SPVDetails_Summary'[TotalRooms],
    'Lettings Fact_SPVDetails_Summary'[SPV], [SPV],
    'Lettings Fact_SPVDetails_Summary'[Academic_Year], [Academic_Year]
)

    LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, nick9one1 

 

I simulated some data to restore your problem, you can use the lookupvalue formula to see the boolean value.

Total Rooms = 
LOOKUPVALUE (
    'Lettings Fact_SPVDetails_Summary'[TotalRooms],
    'Lettings Fact_SPVDetails_Summary'[SPV], [SPV],
    'Lettings Fact_SPVDetails_Summary'[Academic_Year], [Academic_Year]
)

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

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