Forum Discussion
Delete empty rows using Power BI DAX
Hello Power BI Community Members, Below represents a dummy Power BI table with one ID Column, Four date columns and one project name column which makes a couple of duplicates. Here one project n...
also, you can try a calculated column
isThereAnyDate = if(ISBLANK('Table'[Date1]) && ISBLANK('Table'[Date2]) && ISBLANK('Table'[Date3]) && ISBLANK('Table'[Date4]),false(),true())then filter your data by isThereAnyDate = true condition
do not hesitate to give a kudo to useful posts and mark solutions as solution