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
raymondvis
Frequent Visitor

Avoiding blank rows in generate and summarize table

Hello,

 

First of all I'm new to this community so hello to all of you! 🙂 I need your help in avoiding blank rows in a function I used to create a table using generate and summarize. 

This is the table I use to get the data from. I need an overview for every week per year how many "Aantal trays" belong in that week and are being produced. This is defined as "Proddatum" means the production starts, and "Leverdatum" means the production ends and the product is shipped. If a row matches the 2 criteria it should be included in the sum of "Aantal trays" for that week:
1. Proddatum <= Weeknumber
2. Leverdatum > Weeknumber

 

 

 

This is the code I use to summarize the information per week:

 

 

 

And this is the resulting table from that code below. As you see some rows in the column "Aantal trays" are empty. I want to find a way to remove these rows from this table. Currently for every unique Artikelnr+Traytype+Variant column item a row is added per week. But in order to keep this table as small as possible, the blank rows should not be created/added. How do I do this?

 

 

Hopefully somebody knows a way how. Thank you in advance!

 

Kind regards

Raymond

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @raymondvis ,

 

Check if rolluogroup() function can help.

https://docs.microsoft.com/en-us/dax/summarize-function-dax#with-rollupgroup 

Or you could just use filter() function to filter the summarized table.

new table = filter(summarized table, column<>blank())

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

1 REPLY 1
v-jayw-msft
Community Support
Community Support

Hi @raymondvis ,

 

Check if rolluogroup() function can help.

https://docs.microsoft.com/en-us/dax/summarize-function-dax#with-rollupgroup 

Or you could just use filter() function to filter the summarized table.

new table = filter(summarized table, column<>blank())

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

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