Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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] )
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
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] )
this is way better that joins, thanks. Will work on new columns more.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |