cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Find different values from specific dates

Hi.

 

We try to sort a list of activities.

 

We have two different activities called " DOK§4-18 varsel" and "DOK §7-10 varsel".

 

These are two different letters sent out to our customers. The first letter sent out to a customer is "4-18", and some of these customers receive the "7-10" letter as well. If they receive the "7-10" letter, the letter has to be sent to the customer within a year of the date the "4-18" letter was sent.

 

Our question is, is it possible to sort the customers who have received the "7-10" letter after a year has passed? 

 

Underneath is an example of how our table looks, "utført dato" is the date the letter was sent. 

 

Skjermbilde.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Find different values from specific dates

Hi @sk5027383,

 

I'd like to suggest you use activities name and sender id to find out records and stored in variable, then use minx and maxx functions with variable table to get first and last date.

Finally, you can simply use datediff to get diff from above result.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Find different values from specific dates

Hi @sk5027383,

 

I'd like to suggest you use activities name and sender id to find out records and stored in variable, then use minx and maxx functions with variable table to get first and last date.

Finally, you can simply use datediff to get diff from above result.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors