Forum Discussion
Check Duplicates Values
Hi guys, I have a table called "flancamento" and I would like to find duplicate rows. I thought of a solution that would return duplicate values in a new column. Then I am creating a calcu...
karinafreitass , Your formula seems fine. Hope you are creating a new column.
You can have new column like
if( countx(filter(fLancamento,fLancamento[Lançamento] =EARLIER(fLancamento[Lançamento])),fLancamento[Lançamento]) >1 , 1, blank())
New measure like
if( countx(filter(allselected(fLancamento),fLancamento[Lançamento] =EARLIER(fLancamento[Lançamento])),fLancamento[Lançamento]) >1 , 1, blank())
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.