Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jamesc926
Frequent Visitor

Need to Count Blanks at Month End and they need to remain static if action was taken following month

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

jamesc926_1-1701276350485.png

jamesc926_2-1701276582811.png

 

 

 

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

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:

vjunyantmsft_0-1701397142859.png

But these values are not correct in the picture you give below:

vjunyantmsft_1-1701399737505.png


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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors