Define Data Types as per the First Row in Power Query

preview_player
Показать описание

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

- - - - Blogs from BIccountant (Imke) - - - -
Рекомендации по теме
Комментарии
Автор

Great Video as always. how would you tackle a colum that is a mixture as I have a column that is a Unique ref number (URN) sometimes all numbers other text or a mix ie: 123456, DobbSW, AMA001. as the list is A-Z it detects the list as a Number as thats the first entry but then all the text ones show as an error

DinoDelight
Автор

Please, where's the link of the previous video you recommended watching at the beginning of this video?

SndfOmar
Автор

Hi Chandeep. Another awesome video! Thanks for showing this technique :)) Thumbs up!!

wayneedmondson
Автор

Thank you for this great video! Can we create a custom function out of this DataType query?

AHMEDALDAFAAE
Автор

I liked this video, thanks. How do you deal with locale differences, like . or, as decimal separator?

szisziszilvi
Автор

Hello, amazing videos!!!

Why do you allways transpose again the table intead of using directly Table.Torows?

PEDRUSCOT
Автор

What if am having a column like codes which is having both number and text & column data type need to be considered as text?? Please help me out if there's a way to do this dynamic??

VishnuVardhan-okxl
Автор

Hi, how can that be applied on the round off? Thanks

jhajibuganas
Автор

Hi Chandeep!
Using dynamic Datatype how can we change datatype using function value.type
datetime to date and
number to Percent or
Number to whole number

Osmanfayyaz
Автор

Hello, my PQ identifies a column with numbers as text. I don't know what's wrong (even the date type in the excel file is "Number")

ADELINA