How can I create the 'Count of Company' column?
This is a distinct **bleep** of 'Company' in relation to 'Candidate + Date' field.
So '90721-24/08/2020 14:23:00' has 3 distinct 'Company's'
And '90721-21/08/2020 10:35:00' has 5 distinct 'Compant's'
Go to Solution.
@HenryJSUse it as a new column
Column = CALCULATE( DISTINCTCOUNT('Table'[Company]), ALLEXCEPT('Table','Table'[Candidate + Date]))
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
View solution in original post
@HenryJS , new columns
countx(filter(table, [Candidate + Date] =earlier([Candidate + Date])),[Company])orcalculate(distinctcount([Company]) ,filter(table, [Candidate + Date] =earlier([Candidate + Date])))
Proud to be a Super User!
@HenryJS - I'm thinking:
VAR __Table = FILTER('Table',[Candidate + Date] = EARLIER([Candidate + Date]))
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.