Forum Discussion

viitama's avatar
viitama
Frequent Visitor
8 years ago
Solved

conditional join

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 ...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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]
)
itcloud_Learn's avatar
itcloud_Learn
Frequent Visitor
3 years ago

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