how to enter row level formula in Power BI

[SunilPatil]

Team,

I have One column, i simple want to chech whther record is duplicate or not.. by comaring two rows on same column.. How do i enter row level formula in power BI 

Please suggest

In Excel I normally do that if A2=A3 then true ,false and so on

[v-ljerr-msft]

Hi @SunilPatil,

---

I have One column, i simple want to chech whther record is duplicate or not.. by comaring two rows on same column.. How do i enter row level formula in power BI 

---

If you simply want to check whether the record is duplicate or not within the column, you should be able to use the formula(DAX) below to create a new calculate column in your table in this scenario. 

IsDuplicate =
IF (
    CALCULATE (
        COUNTA ( 'Table1'[Column1] ),
        FILTER ( ALL ( 'Table1' ), 'Table1'[Column1] = EARLIER ( 'Table1'[Column1] ) )
    )
        > 1,
    "Yes",
    "No"
)

Note: You will need to replace 'Table1'[Column1] with your real table name and column name.

Regards

[SunilPatil]

Oh.. Thanks a lot

[v-ljerr-msft · Accepted solution]

Hi @SunilPatil,

Great to help! Have you tried it? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. 

Regards

[SunilPatil]

Team, 

Any update on How to entry Row level formula as mentioned below.

[ImkeF]

There's some very good introduction material available, this includes your question: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-4-advanced-data-sources-and-t...