Forum Discussion
Filter with empty rows
Hi PBI Community, I'm new in Power BI and I'm struggling with a table. It's a bit complex (for me :P) and I'd really appreaciate any guidance or help. I have the table below. I want to keep ...
stacey I think where the issue, can you describe the logic why you are getting C and D in your result set (on your original post)
- keep the topics that are between "2weeks before today and 2weeks after today"
- keep the topics that are empty i.e have no next milestone (like topic B)
- if topics include both empty fields and text fields, then keep only the text fields.