Forum Discussion
Data source update
- Anonymous5 years ago
Here is the function, could you please check with me ?
=Table.TransformColumnTypes(#"Promoted Headers",{{"Month", type date}, {"Market", type text}, {"Team", type text}, {"MD", type text}, {"Ped Calls", Int64.Type}, {"Nurse Calls", Int64.Type}, {"MW Calls", Int64.Type}, {"Pharma Calls", Int64.Type}, {"Other Calls", Int64.Type}, {"Medical Calls", Int64.Type}, {"Total Calls", Int64.Type}, {"Ped Calls %", type any}, {"Nurse Calls %", type any}, {"MW Calls %", type any}, {"Pharma Calls %", type any}, {"Other Calls %", type any}, {"Med Calls %", type any}, {"F2F Calls %", type number}, {"Remote Calls %", type number}, {"Working Days", type number}, {"Call Rate", type number}, {"Call Sub Time in Days", type number}, {"%A", type number}, {"%B", type number}, {"Avg A freq", type number}, {"Avg B freq", type number}, {"Coaching sessions", Int64.Type}, {"Column40", type any}, , {"A", Int64.Type}, {"B", Int64.Type}, {"% A", type number}, {"% B", type number}, {"rest A", type number}, {"rest B", type number}, {"Double", Int64.Type}})