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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Smits474
Frequent Visitor

Column with multiple checks

Hey guys,

 

I want to add a column with a calculation but i don't know the right formula to create it.

 

I want to check if the date in a cell matches the date in the next cell in the same column,

If this if true, i want to check if the matching cells have the same 'name of person' in the next column,

If this is true, i want to check which timestamp is the first one.

 

I then want to add the date value + test 1 as value in the new column

For the next cell, i want to ad the date value + test 2 as value in the column

 

Thanks in advance,

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I was a little too fast in my example, that will sequence all events from same person regardless of the date.

 

To also consider sequence with each individual day you can alter the code to:

Sequence =

var curPerson = [Person]

var curTime=[TimeStamp]

var curDate = [TimeStamp].[Date]
return FORMAT([TimeStamp],"YYYY-MM-DD") & " test-" & (COUNTROWS(FILTER(Events, [Person] = curPerson && Events[TimeStamp].[Date] = curDate && Events[TimeStamp] < curTime))+1)

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi,
When you say you want to check if a date matches the date in the "next cell" I guess you mean some other row in your table, right?

In Power BI there is no such concept of next or previous rows since all there is to the engine is tables that consists of one or more columns. 

 

To achive what you are trying to do you need to create some filter that returns the rows in your table that matches your conditions and from them you can evaluate the sequence of timestamps for those rows.

 

Take a look at the following simple example where I have created a column that will create a sequence for all rows with matching date and person

Sequence.PNG 

Anonymous
Not applicable

I was a little too fast in my example, that will sequence all events from same person regardless of the date.

 

To also consider sequence with each individual day you can alter the code to:

Sequence =

var curPerson = [Person]

var curTime=[TimeStamp]

var curDate = [TimeStamp].[Date]
return FORMAT([TimeStamp],"YYYY-MM-DD") & " test-" & (COUNTROWS(FILTER(Events, [Person] = curPerson && Events[TimeStamp].[Date] = curDate && Events[TimeStamp] < curTime))+1)

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.