Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
When I have this formel, see belos, can I found what I need but if I change ,Fakturering[Artikeltyp] to ,Fakturering[Artikelkod]
Solved! Go to Solution.
Hi @Malinpetersson ,
Difficult to be certain based on the info provided, but the first thing I would check is whether [Artikelkod] is text data type.
If it is, then your DAX should read:
Fakturering[Artikelkod] IN {"5086", "5131", "5030"}
Pete
Proud to be a Datanaut!
Hi Pete,
Thanks, yes its text, and I cant change it, can you guide me how to chang it? I tried to mark the column and change to number but I then got an error. Can I change it any other way?
//Malin
Hi @Malinpetersson ,
You don't need to change the data type in the data, you just needto write the DAX how I've shown in my example i.e. with " " around the values.
Pete
Proud to be a Datanaut!
Hi @Malinpetersson ,
Difficult to be certain based on the info provided, but the first thing I would check is whether [Artikelkod] is text data type.
If it is, then your DAX should read:
Fakturering[Artikelkod] IN {"5086", "5131", "5030"}
Pete
Proud to be a Datanaut!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |