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...
Interesting approach above. I attempted the above solution and resulted in an error.
However, I was able to replicate a solution using measures to calculate the MAX Date for each date column.
MAX Date1 = MAX ( table[date1] )
MAX Date2 = MAX ( table[date2] )
MAX Date3 = MAX ( table[date3] )
MAX Date4 = MAX ( table[date4] )
Visual is Table w/
Project, and the newly created measures.
i see the only possible error in the statement above - using comma "," as delimiter but not semicolon ":". It is the locale question and it is not error
do not hesitate to give a kudo to useful posts and mark solutions as solution