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 there,
I know there has been a lot posts about this topic, but I've tried a lot of provided solutions, not working, so I create another post.
Want to create a new column in TableA, if a value in [Page] Endswith value in TableB, then return the value in TableB.
Sample Data in TableA
TableB:
Vanity ID |
/12957349875069381 |
/migra-2214 |
/sport_z1_presenter |
/z1 |
Expected result
I tried use DAX but seems all returns "FALSE". Tried to use M as well, but as this post mentioned, have no idea why it was loading over 41GB without ending.....still loading....
Thanks in advance for your inputs.
Have a good day.
Solved! Go to Solution.
@h_l , Try a new column in Table A like
maxx(filter(TableB, right(TableA[Page],len(TableB[Vanity ID])) = Table[Vanity ID]), Table[Vanity ID])
@h_l , Try a new column in Table A like
maxx(filter(TableB, right(TableA[Page],len(TableB[Vanity ID])) = Table[Vanity ID]), Table[Vanity ID])
@amitchandakThanks for reply, however, after I applying the DAX, Power BI keeps in "Working..." for hours...until now, still "Working...", the symptom looks really like the "Loading...." issue in my another post.
I assume it's because some specific value is existing in TableB, such as:
/b80de788-69b7-4104-b9e0-e08620201476
But it's weird, coz I've set the column in TableB as "text", imo, no matter what value inside, shall not impact how Power BI working...
I am doing test...
By the way, if I would like to just check if a value in [Page] contains (not Endswith) value in TableB, then return the value in TableB, could you please advise a new DAX?
Thanks again!
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |