Forum Discussion

mm5308's avatar
mm5308
Icon for Helper I rankHelper I
4 years ago
Solved

Create New Table Based on DIstinct Values of One Column and Calculated Values of Another Column

I've been searching around for a couple hours now and can't figure out what I'm missing...hopefully someone here can guide me to the right solution.   Out of a large table, I want to create a small...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try:

    New Table = 

    ADDCOLUMNS(
    DISTINCT('Table'[ID]),
    "Post", CALCULATE(MIN('Table'[PostedDate]), ALLEXCEPT(Table, Table [ID]))
truptis's avatar
truptis
Icon for Community Champion rankCommunity Champion
4 years ago

Hi mm5308 ,

Try this:

Earliest Date result = CALCULATE( MIN ( tablename[posted date] ), ALLEXCEPT(tablename, tablename[id] ) )

  • mm5308's avatar
    mm5308
    Icon for Helper I rankHelper I
    4 years ago

    This works as a partial solution because it only addresses the "Post" calculation instead of creating the whole table. Nonetheless, good contribution. Thanks.