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

ErikHamoen's avatar
ErikHamoen
Resolver I
5 years ago

Hey Ingrid,

 

You can try the following:

 

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

 

Kind regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks ErikHamoen 🙏 this returns the values I needed.