hi, i have a table that contain the fo,owing colums:
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
what is the correct syntax to create a calculate column ??
Solved! Go to Solution.
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...
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.