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 ...
Those blank lines probably aren't null. Power Query would show if they are. If they arent null, I'd replace them by right clicking on an empty cell, click replace value, leave the value to replace as is and enter null in as the new value. I'd do that for all columns. Alternatively and assuming that the blank cells don't have any length, you can modify your formula to this:
=
IF (
LEN ( 'table'[NextMileStone] ) < 1,
BLANK (),
DATEDIFF ( TODAY (), 'Table'[Next Date], DAY )
)
