Forum Discussion

Moni's avatar
Moni
New Member
4 years ago
Solved

To calculate distinctcount date with text type

I gotta column with weekending dates and another coulumn with full name, so im trying use DAX to calculate distinct value of each full name with no of weeks,    I'm getting error with full name as ...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Moni just to be sure, you put 'Table[Full Name] on rows of the matrix and created this measure:
    Distinct Weeks Measure = DISTINCTCOUNT('Table'[Week Ending]) 
    And put that measure on the values and it didn't work?

rohit_singh's avatar
rohit_singh
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Moni ,

Adding name and distinct count of week ending gives me 2 weeks for both persons.


Not sure what exactly your expected output is?


Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! ğŸ˜Š

Moni's avatar
Moni
New Member
4 years ago

Hi rohit_singh 

 

I tried, changing count and everything

I tried those measures, it calculates distinctcount of weekending but not name, example it shows

 

Darren 7 weeks

Gareth 2 weeks

 

but i expect answer,

 

Daren 2 weeks (since 12/11/2021, 19/11/2021 only two days are ter)