New Column with Only Distinct Values from Another Column

[Anonymous]

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 first time a value is mentioned to look something like the following: 36, 45, 23, (blank). What DAX function should I use for this new column?

[v-chenwuz-msft]

Hi @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.

[ribisht17]

@Anonymous 

Solution = if(RANKX(ALLEXCEPT('Table','Table'[Marks]),CALCULATE(min('Table'[Name])),,,Dense) > 1,"",SUM('Table'[Marks]))

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users