Forum Discussion

nelson777's avatar
nelson777
Frequent Visitor
4 years ago

Summarize Bringing Max and Min Dates

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

2 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    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/

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.