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 have the following challenge for Power BI:
I want to count the number of "Orders" with a Result different to "Realizado", but with the following conditions:
For example:
Order | IC Client | CUP | Fecha inicio extrema | Result |
13833842 | 10000028 | ES02341500157 | 11/02/2018 0:00 | Imposible realizar |
13864396 | 10000028 | ES02341500157 | 27/02/2018 0:00 | Innecesario |
13759224 | 10000030 | ES02341500223 | 16/01/2018 0:00 | Imposible realizar |
13727349 | 10000072 | ES023411gg0TJ | 29/12/2017 0:00 | Imposible realizar |
13727345 | 10000072 | ES023411gg0TJ | 30/12/2017 0:00 | Imposible realizar |
13728120 | 10000072 | ES023411gg0TJ | 03/01/2018 0:00 | Imposible realizar |
13733794 | 10000072 | ES023411gg0TJ | 05/01/2018 0:00 | Imposible realizar |
13722089 | 10000125 | ES023415257DF | 28/12/2017 0:00 | Imposible realizar |
13878184 | 10000125 | ES023415257DF | 01/03/2018 0:00 | Realizado |
For this example, the count of "Orders" with the conditions would be equal to 3 ("IC client"= 10000028 with "Order"=13833842 and 13864396;"IC client"=10000030 with "Order"=13759224).
Thank you very much in advance.
Solved! Go to Solution.
But this IC Client 1000002806 has third row equal to Realizado
Why is it considered while 10000125 is ignored?
Hi Zubair_Muhammad, you are right. My mistake in posting the example table. I fixed it.
Also right. Fixed.
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 |