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 ...
ribisht17
Super User
Super UserAnonymous
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