Forum Discussion

stacey's avatar
stacey
Frequent Visitor
2 years ago

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 ...
Need Help
stacey's avatar
stacey
Frequent Visitor
2 years ago

Thanks for the reply.
It gives the same result.

 

danextian's avatar
danextian
Super User
2 years ago

What does the calculated column show in data view? Please also show those colums in Power Query.

  • stacey's avatar
    stacey
    Frequent Visitor
    2 years ago

     

    • danextian's avatar
      danextian
      Super User
      2 years ago

      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 )
)
      • stacey's avatar
        stacey
        Frequent Visitor
        2 years ago

        Thanks for the reply. Unfortunately it doesn't work. 
        I'll try  to find some other workaround.