Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
actroyani
Regular Visitor

Check if a value exists previously

Hi,

I would like to know how to create a new column where I get the value "New" if a person exists in previous months of my data and "Old" if it exists in previous months or if it's the first month of data.

I have a table like this:

DatePerson
15/11/2021A
13/11/2021A
12/11/2021B
10/11/2021C
20/10/2021A
15/10/2021C
10/10/2021C
15/09/2021A

Take into account that individuals may appear more than once on a month, so this is what I would like:

DatePersonColumn
15/11/2021AOld
13/11/2021AOld
12/11/2021BNew
10/11/2021COld
20/10/2021AOld
15/10/2021CNew
10/10/2021CNew
15/09/2021ANew

Thanks in advance!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@actroyani ,

a new column =

var _1 = countx(filter(Table, [Person] = earlier([Person]) && [Date] < earlier([Date] ) ), [Person]) +0

return

if(_1 > 0, "Old", "New")

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@actroyani ,

a new column =

var _1 = countx(filter(Table, [Person] = earlier([Person]) && [Date] < earlier([Date] ) ), [Person]) +0

return

if(_1 > 0, "Old", "New")

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.