topic Summarize Bringing Max and Min Dates in DAX Commands and Tips

Summarize Bringing Max and Min Dates

nelson777 — Mon, 18 Jul 2022 00:28:07 GMT

Hi, legends,

I'm trying to summarise a table and get the first and last date of the occurrence I'm grouping by.

I tried to get there through similar solutions for older posts here, but couldn't make it work properly.

The formula I'm using is bringing the overall min and max date, and I need it to iterate by rows.

This is what I did:

Table = SUMMARIZE(test, test[Name], "First Seen", MIN(test[First Seen]), "Last Seen", MAX(test[Last Seen]))

and the result I got:

which, as you can see, all the dates are the same for "first seen" and "last seen"

How do I bring the min and max dates for each of the names I'm summarizing?

TIA,

Nelson

Re: Summarize Bringing Max and Min Dates

VahidDM — Mon, 18 Jul 2022 01:20:12 GMT

Hi nelson777

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

Re: Summarize Bringing Max and Min Dates

v-yalanwu-msft — Wed, 20 Jul 2022 02:43:06 GMT

Hi, nelson777 ;

I tested it and it works well.

1. orginal table.

2.new table.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.