Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 text type cannot be used as true/false or text type cannot be used in filter with distinct count.
can anyone help me please.
I want output to be gareth 2 weeks, Darran 1 week (since 12/11/21 repeating so distinct count)
Solved! Go to Solution.
Measures don't have to be wrapped in CALCULATE as the engine does it automatically.
So, the final formula would be:
Nbweek = DISTINCTCOUNT( Weekending[WeekEnding] )
Hi @Anonymous
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |