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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CVanpat91
Frequent Visitor

Previous date that a specific Value appears

Hello,

 

I have a set of data where a certain value appears multiple times.  I want to know the date that the previous value appeared to the current date.  Example below of data.  

NameDate
Blue1/1/2022
Red8/4/2021
Blue5/1/2021
Blue4/2/2021
Green4/1/2021
Green2/3/2021

 

Example of what I need for results: 

NameDatePrevious Date
Blue1/1/20225/1/2021
Red8/4/2021null
Blue5/1/20214/2/2021
Blue4/2/2021null
Green4/1/20212/3/2021
Green2/3/2021null

 

 

Any help would be greatly appreciated.  Thank you in advance!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@CVanpat91 ,

A new column

 

maxx(filter(Table, [Name] =earlier([Name]) && [Date] <earlier([Date]) ) , [Date])

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@CVanpat91 ,

A new column

 

maxx(filter(Table, [Name] =earlier([Name]) && [Date] <earlier([Date]) ) , [Date])

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.