Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |