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]))
mm5308's avatar
mm5308
Icon for Helper I rankHelper I
4 years ago

Thank you both for your replies! The accepted solution worked perfectly. When I first saw the new table, I was scared because all the visible "Post" dates were all the same still. But when I clicked the drop-down arrow on that column, it showed that there were indeed a ton of PostDate values. The metadata at the bottom confirmed as much.

 

Realizing this "check the data" error, I wondered if my original DAX expressions worked without me realizing it because I'd focused only on the visible results. Turns out, the third expression above (that starts with SUMMARIZE) actually did work. I feel silly for posting now.

 

Again, thanks to the two users who helped. More than a simple solution to this particular problem, I learned a more valuable lesson: check my work better (and don't be in a rush)!