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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
cplesner
Helper III
Helper III

Find dates until next event from filtered start and end events

Hi

 

I would like some input on how to get the best performing DAX calculation for calculating time between selected events. Let say i have below source table with millions of people and events.

Udklip1.PNG

 

In my PowerBI matrix I would like to be able to select a Start Event and an End Event and then have it show the following

Udklip2.PNG

Or if i select another filter, then this

Udklip3.PNG

 

Any help is appreciated

 

1 REPLY 1
littlemojopuppy
Community Champion
Community Champion

Can you paste some data to work with?  Difficult to work with pictures

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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