Forum Discussion
New Column with Only Distinct Values from Another Column
In my table I have a column, Day Count, that has number of days, with a given number potentially repeating ex. 36, 45, 23, 36. I want to create a new column, Distinct Day Count, that only stores the ...
v-chenwuz-msft
Community Support
Community SupportHi Anonymous ,
You can try create a new table via
new table = UNION( VALUES( 'Table'[Another column] ), {""})
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.