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.
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
Solved! Go to Solution.
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
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
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |