DAX formula to return Value from another table based on boolean value

[Anonymous]

I have a model with 3 tables (Dates, Views and Fact Table). Dates and Views are connected to the Fact Table through ID_Date below.

How can I write a formula that instead of the boolean fields below would return the Values? i.e. replace the booleans by the corresponding value for that date. So for instance "View LTM23_DAX" would return the Values for the months marked as "1" under "View LTM23".

Any help is very appreaciated! As mentioned the tables are connected. 

[Anonymous]

Hi @Anonymous ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.