Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
hi, i have a table that contain the fo,owing colums:
name date
jonthan 19/11/2017
jonthan 20/11/2017
josef 20/11/2017
omar 20/11/2017
jonthan 20/11/2017
josef 19/11/2017
i whant to create a related table that show the folowing information when i select the dates between 19/11/2017 and 20/11/2017
name total days
jonthan 3
josef 2
omar 1
what is the correct syntax to create a calculate column ??
thanks.
Solved! Go to Solution.
Hi @davidi4524,
Look at your original question carefully - COUNT is exactly what you wanted. Anyways, for your changed question now, try this
=DISTINCTCOUNT(Data[Date])
If you want a distinct count for my solution, simply select 'Distinct Count' from the dropdown instead of 'Count'.
If you want simply display the table, you can do that with just a couple clicks using the Table visual. Just drag the 'Name' column onto the table twice. Click the drop down arrow and select 'Count'. Then, create a filter using your Date column. Be sure that it's formatted as a date or date/time or you won't see the slider, you'll see check boxes.
If you want to create a brand new table...
ok but i need to count distinct the numbers of the records per the username between dates. this solusion is only make a subtotal per username
If you want a distinct count for my solution, simply select 'Distinct Count' from the dropdown instead of 'Count'.
ok but i need to count distinct the numbers of the records per the username between dates. this solusion is only make a subtotal per username
Hi @davidi4524,
Look at your original question carefully - COUNT is exactly what you wanted. Anyways, for your changed question now, try this
=DISTINCTCOUNT(Data[Date])
Hi,
This should not be a calculated column but a measure. Drag the Name, create a date slicer and make any selection. Then use this measure
=COUNTROWS(Data)
Hope this helps.
sorry, i'm new to the dax language. what execly the syntax to make it?
Hi @davidi4524,
Have you tried the solution provided above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
96 | |
89 | |
38 | |
28 |