conditional join

[viitama]

Hi, I'm new to PowerBi and trying to figure out how to join conditionally. I have been able to use merge queries wizard for simple joins, but now I have bit more complex. Here is my two tables and I would like to get Example1 Out column to Example2 table by matching Example2.Date to Example1.StartDate and Example1.EndDate (it should be between those) and Indic. Not sure where I do this, but I would appreciate if answer would incluede some info, where I input my DAX code.

[itcloud_Learn]

Hey Did you got the solution what you were asking i am having the same scernerio. if you got the solution please let me know that would be help ful, i am als having complex join scernerio

[v-chuncz-msft · Accepted solution]

@viitama,

You may refer to the following DAX that adds a calculated column.

Column =
MAXX (
    FILTER (
        Example1,
        Example1[Indic] = Example2[Indic]
            && Example1[StartDate] <= Example2[Date]
            && Example1[EndDate] >= Example2[Date]
    ),
    Example1[Out]
)

[viitama]

this is way better that joins, thanks. Will work on new columns more.