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