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

AlB's avatar
AlB
Community Champion
5 years ago

Hi Anonymous 

You could do something like:

New Table =
ADDCOLUMNS (
    DISTINCT ( Table1[NrClient] ),
    "DatumIngang", CALCULATE ( MIN ( Table1[Ingang] ) )
)

 You might have to filter the first argument of the ADDCOLUMNS. If you explain what the filter exactly does in your code (I don't see it completely), we can get to a more accurate answer

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers