Power Query Flashcards

1
Q

Technical Date syntax

A

Year month day

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Technical date conversion (via formula)

A

use comma and the convert function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Time - Duration

A

Select end of first and after start and then in add column use the Duration option

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly