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.
I have data with several dates and at month's end I need to count the number of Serial for the month and show in a bar chart the total Not Shipped, total Not Installed, total Not Integrated - these monthly totals need to remain static even if action was taken on following months (if serial 8704 was installed in Nov I still need to report 4 not installed for Order Month of Sept)
How can I accomplish this?
Thanks in advance for any and all assistance
Hi @jamesc926 ,
Can you elaborate on the formula for total Not Shipped, total Not Installed, total Not Integrated? According to your description, I understand it is to calculate the number of rows in the table where the corresponding three columns of date records are empty:
But these values are not correct in the picture you give below:
Best Regards,
Dino Tao
Dino - I would need three formulas, one for each (not shipped, not install, not integrated)
not ship= Countrows (if (Order Month = 8 && Ship Date isblank)) so the Serial Not shipped in Order Month 8 that would be counted is the Not Assigned.
However when this Serial is assiged and shipped the Total Not Shipped for Order Month 8 needs to remain at 1
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
104 | |
69 | |
49 | |
41 | |
34 |
User | Count |
---|---|
164 | |
111 | |
62 | |
53 | |
38 |