CROSSDAX

Edit Answers
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
Across
  1. 2. Case-switch function
  2. 3. Conditional function
  3. 5. Extracts the month from a date
  4. 8. Aggregates year-to-date
  5. 9. Converts to lowercase
  6. 11. Defines a variable
  7. 12. Creates a table from rows
  8. 13. Extracts the year from a date
  9. 14. Returns common rows between tables
  10. 16. Creates a one-row table
  11. 17. Adds up value in a column
  12. 18. Combines tables
  13. 21. Logical AND
  14. 22. Converts to uppercase
  15. 25. Compares if two strings are exactly the same
  16. 27. Creates a time value
  17. 30. Replaces part of a string
  18. 32. Logical OR
  19. 33. Finds the largest value
  20. 34. Returns the logarithm
  21. 35. Removes filters
  22. 36. Gets characters from the left
  23. 39. Calculates the standard deviation
  24. 40. Checks if table contains a row
  25. 41. Returns current date
  26. 42. Adds a number of months to a date
  27. 43. Extracts the second from a time value
  28. 44. Extracts the minute from a time value
  29. 47. Gets characters from the right
  30. 50. Converts a number or date into text
  31. 55. Retrieves related value
  32. 56. Performs integer division
  33. 58. Adds geographical data to a table
  34. 59. Ranks numbers with duplicate ranks
  35. 60. Extracts the day from a date
  36. 62. Joins tables with existing relationships
Down
  1. 1. Gets dates year-to-date
  2. 4. Filters a table
  3. 5. Finds the middle value
  4. 6. Removes all filters except one or more
  5. 7. Returns the username
  6. 9. Counts number of characters
  7. 10. Performs division safely
  8. 14. Checks if a value is in a list
  9. 15. Adds values over time
  10. 16. Ranks numbers
  11. 17. Returns the square root
  12. 19. Logical NOT
  13. 20. Changes filter context
  14. 23. Returns the path from a parent-child hierarchy
  15. 24. Treats a table as having different context
  16. 25. Returns the end of the month
  17. 26. Creates a table with rolled-up totals
  18. 28. Checks for a blank value
  19. 29. Returns a table from an expression
  20. 31. Creates a calendar table
  21. 37. Returns differing rows from first table
  22. 38. Calculates the difference between two dates
  23. 40. Counts the number of rows
  24. 44. Finds the smallest value
  25. 45. Returns current date and time
  26. 46. Refers to earlier row
  27. 48. Returns unique values
  28. 49. Returns a blank value
  29. 51. Multiplies values in a column
  30. 52. Returns an item from a path
  31. 53. Finds a string within another
  32. 54. Extracts the hour from a time value
  33. 57. Gets the weekday from a date
  34. 61. Calculates the average