Power Querry

Question 1

remove duplicates

Answer 1

right click on a column of observations
select remove duplicates

Question 2

text before delimiter

Answer 2

select your column
select data tab
select extract
select text before delimiter
choose delimiter

Question 3

date function

Answer 3

if you want to find out the difference between two dates in two separate columns:

select both columns
select add column tab
select date
select subtract days

Question 3

subtract, multiply, divide, or add any columns

Answer 3

select both columns
select add column tab
select standard
select the function you want to apply