Power Query Flashcards
1
Q
Technical Date syntax
A
Year month day
2
Q
Technical date conversion (via formula)
A
use comma and the convert function
3
Q
Time - Duration
A
Select end of first and after start and then in add column use the Duration option
4
Q
Date and number from a file where used a different region setting: Answer two options
A
Option a: Use Locale in your Type Transformation
Option b: Use Query Option setting Current Workbook