March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have two tables, firstone identifiants, which has id column as below :
second table informations, which has information id column as below:
I added a custom column check in identifiants table to check if id exists (TRUE) or not (FALSE) in information id column in informations tabe.
please what's the solution for that?
Solved! Go to Solution.
@Greg_Deckler , correct me if I am wrong but I dont believe Text.Contains will work on its own as it doesnt work with a list of values... ?
Perhaps something like this instead:
=Text.Contains(Text.Combine(informations[informations id]),[id])
Hi @Mourad_Analyst ,
to my understanding of the problem, it seems to work alright (as the fields in information id don't seem to match those of the id column.
So maybe my understanding of the problem is incorrect.
Could you please upload sample data in a way so that it can be used to provide a correct answer:
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Also, please indicate what result exactly you expect for reach row of the sample data.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Agreed with this. Please provide some sample data and a sample output as to what you're expecting to accomplish. That will allow us to see things more clearly
Hi @Mourad_Analyst ,
could you merge the informations table on "information ID" and then instead of expanding the resulting table, add a column with the formula "not Table.IsEmpty[MergedColumnName]".
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
@Mourad_Analyst Use this:
AddedCustom =
Table.AddColumn (
ChangedType,
"Custom",
( CurrentRow ) =>
List.AnyTrue (
List.Transform (
identifiants[ID],
(ID)=> Text.Contains ( CurrentRow[information id], ID )
)
),
Logical.Type
)
@Greg_Deckler , correct me if I am wrong but I dont believe Text.Contains will work on its own as it doesnt work with a list of values... ?
Perhaps something like this instead:
=Text.Contains(Text.Combine(informations[informations id]),[id])
@Mourad_Analyst Use Text.Contains
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
24 | |
13 | |
11 | |
10 | |
7 |
User | Count |
---|---|
43 | |
26 | |
18 | |
16 | |
11 |