Require quite a complex DAX formula - set 1 based on two different criteria

[arob_trillium]

Hey there, first time poster, so apologies if this is a bit of a 'noob' question.

I have a table, that currently counts the number of times a case_id appears on the list. Based on that number it then selects how may times the case has been rebooked.

All this is fine, however I need a way to remove duplicates, and I was struggling as there is no obvious way to do this, outside of exporting to excel and removing the duplicates. Then I had a thought last night, if I could create a new column with a dax formula in that gets set to 1, based on the following two reasons.

1) Unique case id value, not repeated on the table

2) Not a unique case id value, but only set the newest created on date to 1 and ignore all older ones.

Is that possible?

Alex

[HotChilli]

Alex, welcome to the forum, no apologies required about the question.

Post a sample of your data (not a picture) and show us what your desired outcome is. Let's put aside the theory about making a column = 1.  Show us what the issue is.

Someone will help and I can confidently state it won't require exporting to Excel.