topic Re: New Column with Only Distinct Values from Another Column in DAX Commands and Tips

New Column with Only Distinct Values from Another Column

Anonymous — Fri, 22 Jul 2022 17:06:01 GMT

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?

Re: New Column with Only Distinct Values from Another Column

ribisht17 — Fri, 22 Jul 2022 18:23:23 GMT

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

Re: New Column with Only Distinct Values from Another Column

v-chenwuz-msft — Tue, 26 Jul 2022 10:13:26 GMT

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.