How do I check a certain count in my dataset?

[Anonymous]

Hi folks,

I know the question seems vague but let me explain what solution I am hoping to arrive for. I have a dataset that looks something like this as seen in the Picture.

The excel file lists the table that has columns as seen. I need an additional column say "Column-E" that will actually have values as "Y" or "N". The logic for determining "Y" / "N" will be based on the fact that if the user has entity name updated more than 5 times. Hence in example, the user Admin_123 has updated entity more than 5 times (clearly 6 different "_" values) are visible. How do I write a logic of that? 

Simple Logic: If the entity (Column-B) is updated more than 5 times, the column-E would be "Y" else "N"

Data Source: Excel

S/w: Power BI Desktop

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your desired output.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

From your description, I still have a question.

How to determine if the column Entity Name is updated? As we can see that all of values in the column EventText show update.

Could you explian it's logic so that I could understand your scenario better?

I also would appreciated it if you could show your  desired output.

Best  Regards,

Cherry