cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft v-ljerr-msft
Microsoft

Re: How to use an if statement to create a column based on values from 2 tables

Hi @Baldy,

 

Based on my test with your sample data, you should be able to use the formula(DAX) below to create new calculate column in Table1 in your scenario. Smiley Happy

Column3 =
CALCULATE (
    FIRSTNONBLANK ( Table2[Column4], 1 ),
    FILTER (
        Table2,
        Table2[Column1] = Table1[Column1]
            && ( Table1[Column2] >= Table2[Column2]
            && Table1[Column2] <= Table2[Column3] )
    )
)

c1.PNG

 

Regards

View solution in original post

Baldy Frequent Visitor
Frequent Visitor

Re: How to use an if statement to create a column based on values from 2 tables

This works perfectly.

 

Thank you to every one for your time it is very much apritiated

Alan

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,343)