Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How do I DAX a new table from the following:

Given the below, I would like the result to be two columns, with distinct contractnbrs in 1 column and the coresponding leasenumbers in another.  I only want one of each leasenumber, and no blanks.  ...
Need Help
Shalini_T's avatar
Shalini_T
Frequent Visitor
2 years ago

Anonymous, Try this code in a calculated table,

New_Table = 
VAR _summarize = SUMMARIZE('Table','Table'[contractnbr],"leasenumber",MIN('Table'[leasenumber]))
RETURN _summarize

 


Regards,
Shalini

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It says the syntax for 'RETURN' is incorrect.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Also, need ALL the leasenumbers for each contractnbr.