Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create new table with MIN date

I want to create a new table from my table with customerId and startdates which returns one row per customer with the minimum dat per customer. I've tried to use SELECTCOLMUNS and FILTER and I get a ...
Need Help
  • ErikHamoen's avatar
    ErikHamoen
    5 years ago

    Hey Ingrid,

     

    You can try the following:

     

    MinFvoorzieningTbvEerste=
    SUMMARIZE (
        'FvoorzieningTbvEerste',
        'FvoorzieningTbvEerste'[NrClient],
        "ingang", MIN ( 'FvoorzieningTbvEerste'[Ingang] )
    )

     

    Kind regards

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

I would make this table in the query editor with a Group By step.  Or you should use ADDCOLUMNS(SUMMARIZE(... instead of SELECTCOLUMNS which doesn't do any aggregation.

 

Regards,

Pat