Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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,
Solved! Go to Solution.
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)
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
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)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
72 | |
56 | |
40 | |
35 |
User | Count |
---|---|
71 | |
65 | |
57 | |
49 | |
47 |