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 here,
And I have a question about querying data in Power BI
I want to select an item from a range of receipts. This article can appear in several coupons.
I want a list of all articles in which this article appears. can I fix that with DAX
Good evening, I have fed a data set. of this set I would like to show the whole set of a [TRANSACTIENR] all [ARTIKELNUMMER]. ARTIKELNUMMER = 120590
you will then see all the articles that appear in a set containing nr 120590 onle set 209
VESTIGING | DATUM | TRANSACTIENR | ARTIKELNUMMER | OMSCHRIJVING_L | AANTAL |
5061 | 30-jan-21 | 207 | 258116 | TINTELFRUIT APPEL CRANBERRY | 1 |
5061 | 30-jan-21 | 207 | 661190 | IJSCUPS BRUIN | 1 |
5061 | 30-jan-21 | 207 | 451160 | BONI BROODJE | 1 |
5061 | 30-jan-21 | 207 | 257748 | HOUDBARE VOLLE MELK | 1 |
5061 | 30-jan-21 | 207 | 257748 | HOUDBARE VOLLE MELK | 1 |
5061 | 30-jan-21 | 207 | 451394 | TIJGERBOLLEN | 1 |
5061 | 30-jan-21 | 207 | 201685 | VANILLE IJS | 1 |
5061 | 30-jan-21 | 207 | 289697 | TORTILLA CHIPS NACHO CHEESE | 1 |
5061 | 30-jan-21 | 207 | 293601 | PISTACHENOTEN GEZOUTEN | 1 |
5061 | 30-jan-21 | 207 | 294258 | VANILLE VLA | 1 |
5061 | 30-jan-21 | 207 | 289698 | TORTILLA CHIPS NATUREL | 1 |
5061 | 30-jan-21 | 207 | 289888 | RONDOS | 1 |
5061 | 30-jan-21 | 207 | 217971 | STUDENTENHAVER | 1 |
5061 | 30-jan-21 | 207 | 310484 | BORREL BITES PAPRIKASWEET | 1 |
5061 | 30-jan-21 | 207 | 293870 | CHOCOLADE PINDAS | 1 |
5061 | 30-jan-21 | 207 | 258115 | TINTELFRUIT APPEL BOSVRUCHTEN | 1 |
5061 | 30-jan-21 | 207 | 296902 | SPELT BROODJE | 1 |
5061 | 30-jan-21 | 207 | 914515 | KIP SHOARMA | 1 |
5061 | 30-jan-21 | 208 | 210083 | ICETEA PERZIK | 1 |
5061 | 30-jan-21 | 208 | 258132 | ZAPPIE TROPISCH | 1 |
5061 | 30-jan-21 | 208 | 408933 | BIG CITY PIZZA ROME | 1 |
5061 | 30-jan-21 | 208 | 408933 | BIG CITY PIZZA ROME | 1 |
5061 | 30-jan-21 | 208 | 408933 | BIG CITY PIZZA ROME | 1 |
5061 | 30-jan-21 | 208 | 219062 | RAVIOLI BOLOGNESE | 1 |
5061 | 30-jan-21 | 208 | 219062 | RAVIOLI BOLOGNESE | 1 |
5061 | 30-jan-21 | 208 | 404446 | KROKETTEN RUNDVLEES | 1 |
5061 | 30-jan-21 | 208 | 403712 | HAMBURGERS | 1 |
5061 | 30-jan-21 | 208 | 710322 | TOMAAT SNOEP SHAKER | 1 |
5061 | 30-jan-21 | 209 | 292070 | MELOEN WATER | 1 |
5061 | 30-jan-21 | 209 | 228922 | KROEPOEK BALI | 1 |
5061 | 30-jan-21 | 209 | 711170 | EIKENBLADSLA MELANGE | 1 |
5061 | 30-jan-21 | 209 | 257725 | KAISERBROODJES | 1 |
5061 | 30-jan-21 | 209 | 257725 | KAISERBROODJES | 1 |
5061 | 30-jan-21 | 209 | 210481 | FRAMBOZEN | 1 |
5061 | 30-jan-21 | 209 | 222770 | AARDBEIEN | 1 |
5061 | 30-jan-21 | 209 | 104120 | SLA | 1 |
5061 | 30-jan-21 | 209 | 104120 | SLA | 1 |
5061 | 30-jan-21 | 209 | 120590 | BANANEN | 1 |
5061 | 30-jan-21 | 209 | 294319 | WRAPHAPJES MET ZALM | 1 |
5061 | 30-jan-21 | 209 | 296426 | MINI GRILLWORST KAAS | 1 |
5061 | 30-jan-21 | 209 | 294315 | SERRANO ROOMKAAS ROLLETJES | 1 |
5061 | 30-jan-21 | 209 | 228915 | KETJAP MANIS ZOET | 1 |
5061 | 30-jan-21 | 209 | 990062 | SCHWARZWALDER SCHINKEN | 1 |
5061 | 30-jan-21 | 209 | 990084 | GEGRILDE HAM | 1 |
5061 | 30-jan-21 | 209 | 499974 | RUNDERHACHEE | 1 |
5061 | 30-jan-21 | 209 | 296450 | ZAK ELSTAR | 1 |
5061 | 30-jan-21 | 209 | 200635 | ROOMBOTER ONGEZOUTEN | 1 |
5061 | 30-jan-21 | 209 | 293838 | PAASEITJES MIX DOOSJE | 1 |
5061 | 30-jan-21 | 209 | 297218 | SPECKLED EGGS | 1 |
5061 | 30-jan-21 | 209 | 219510 | KOMKOMMER | 1 |
5061 | 30-jan-21 | 209 | 219510 | KOMKOMMER | 1 |
5061 | 30-jan-21 | 209 | 296542 | ROOMBOTER GEZOUTEN | 1 |
5061 | 30-jan-21 | 209 | 600570 | FRAMBOOSCRANBERRY | 1 |
5061 | 30-jan-21 | 209 | 121450 | WITLOF | 1 |
5061 | 30-jan-21 | 209 | 915535 | KAAS-GEHAKT STICK 4 ST | 1 |
5061 | 30-jan-21 | 209 | 249810 | HALFVOLLE MELK | 1 |
5061 | 30-jan-21 | 209 | 400639 | BOERENYOGHURT HALFVOL | 1 |
5061 | 30-jan-21 | 209 | 225774 | ZEEZOUT FIJN | 1 |
5061 | 30-jan-21 | 211 | 297704 | WASMIDDEL KLEUR 40SC | 1 |
5061 | 30-jan-21 | 211 | 407072 | KRUIDENKAAS | 1 |
5061 | 30-jan-21 | 211 | 263694 | MINI KLUIVEN | 1 |
5061 | 30-jan-21 | 211 | 263695 | MERGKOEKJES | 1 |
5061 | 30-jan-21 | 211 | 604821 | RIESLING QBA | 1 |
5061 | 30-jan-21 | 211 | 604821 | RIESLING QBA | 1 |
5061 | 30-jan-21 | 211 | 208443 | HALFVOLLE MELK | 1 |
5061 | 30-jan-21 | 211 | 408383 | BELEGEN KOMIJN GSN | 1 |
That is doable. Please share example data (not as an image so we can copy/paste it), to get a specific expression.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |