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 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.

 

 

 

  • 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]
)

3 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    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]
)
    • viitama's avatar
      viitama
      Frequent Visitor
      8 years ago

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

  • 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