Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi helpers,
I have list of vending machines & database is contains Master tables for serial numbers & Sales tables contains "Sales , Qty" I'm facing an issue that if one vending machine doesnt work for one or several days i didnt dicover it.
So I need to know how to check if single or more vending machines not working
Solved! Go to Solution.
please follow these steps :
step 1
create datetable table :
step3 : create this measure :
drag the following columns the visual .
final result :
this will gives the non working hours per #serial .
hope this helps .
best regards
Hi Daniel29195,
Thanks for your replay I tried it but it doesnt work , I need something like how many days this VM operating
are you able to share some data .
with a visual representation maybe on excel, of the desired output.
this would help understanding more your requirement.
Here you are,
Master
Serial # |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
Transaction
Serial # | Date | Amount | Qty |
1 | 01-Jan | 10 | 1 |
2 | 01-Jan | 20 | 2 |
3 | 01-Jan | 50 | 5 |
4 | 01-Jan | 67 | 7 |
5 | 01-Jan | 87 | 3 |
6 | 01-Jan | 107 | 6 |
7 | 01-Jan | 127 | 7 |
8 | 01-Jan | 147 | 8 |
9 | 01-Jan | 167 | 9 |
10 | 01-Jan | 187 | 10 |
11 | 01-Jan | 207 | 11 |
1 | 02-Jan | 227 | 12 |
2 | 02-Jan | 247 | 13 |
3 | 02-Jan | 267 | 14 |
4 | 02-Jan | 287 | 14 |
5 | 02-Jan | 307 | 15 |
6 | 02-Jan | 327 | 16 |
7 | 02-Jan | 347 | 17 |
8 | 02-Jan | 367 | 18 |
9 | 02-Jan | 387 | 19 |
1 | 03-Jan | 407 | 20 |
2 | 03-Jan | 427 | 21 |
3 | 03-Jan | 447 | 22 |
4 | 03-Jan | 467 | 23 |
5 | 03-Jan | 487 | 23 |
6 | 03-Jan | 507 | 24 |
7 | 03-Jan | 527 | 25 |
8 | 03-Jan | 527 | 26 |
please follow these steps :
step 1
create datetable table :
step3 : create this measure :
drag the following columns the visual .
final result :
this will gives the non working hours per #serial .
hope this helps .
best regards
Thanks Alot for your support , it works fine!
All I need to know how can I discover that Serial # 11 , 12 non performing in 02n January & serial numbers 9 , 10 , 11 non performing in 03rd January
hello @hanyfouda2023
try using the show items with no data.
this will show rows even if they don have values
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |