Power Query Change Type Using Locale - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Esteban
Mynda, I really want to thank you for this tutorial. I'm currently trying to learn Power BI to present the project of moving all reporting to Power BI to my bosses in the company where I work, and this video really helped me get started with the software.
Now I have a better Idea on how to start building reports in Power BI.
reply
Mynda, I really want to thank you for this tutorial. I'm currently trying to learn Power BI to present the project of moving all reporting to Power BI to my bosses in the company where I work, and this video really helped me get started with the software.
Now I have a better Idea on how to start building reports in Power BI.
reply
nivedita
Really very helpful video !! Thank you for the explanation!!
Could you please tell how to change the currencies in Power Query. I am getting option of only $ but I want -. Would be really grateful for your help with this. I have searched everywhere but not getting any solution.
reply
Really very helpful video !! Thank you for the explanation!!
Could you please tell how to change the currencies in Power Query. I am getting option of only $ but I want -. Would be really grateful for your help with this. I have searched everywhere but not getting any solution.
reply
Vircan
Hi Mynda - This video is very useful. However, which approach should be used when a data set is loaded into Power Bi and you have for numbers scientific number? Worth to mention that formatting was made in excel and in Power BI the data type was set as decimal.
reply
Hi Mynda - This video is very useful. However, which approach should be used when a data set is loaded into Power Bi and you have for numbers scientific number? Worth to mention that formatting was made in excel and in Power BI the data type was set as decimal.
reply
Dylan
Hi Mynda - as always, very helpful video! Quick question on this functionality though: is it possible to do this for many columns at once? The choice -With Locale- disappears when I select multiple columns, but I have a bunch to change and select.
reply
Hi Mynda - as always, very helpful video! Quick question on this functionality though: is it possible to do this for many columns at once? The choice -With Locale- disappears when I select multiple columns, but I have a bunch to change and select.
reply
Uwe
Checking for errors with the checkbox -column qualiy- doesn't work reliably. In your example errors occur in the column -Budget- in rows 4098 to 4109 if you apply wrongly a German locale. But the errors are not shown in the column quality.
reply
Checking for errors with the checkbox -column qualiy- doesn't work reliably. In your example errors occur in the column -Budget- in rows 4098 to 4109 if you apply wrongly a German locale. But the errors are not shown in the column quality.
reply
Mark
Power BI absolutely insists that locale for South Africa means YYYY/DD/MM. I have never had this before in any other Microsoft product. But thanks for the video to solve the crisis.
Edit: Nope, I see it's doing it in Excel as well now.
reply
Power BI absolutely insists that locale for South Africa means YYYY/DD/MM. I have never had this before in any other Microsoft product. But thanks for the video to solve the crisis.
Edit: Nope, I see it's doing it in Excel as well now.
reply
Leonidas
Excelente, nice tool, Power Query always a marvelous! I use your steps to change format for baseball stats, changing decimal format and now I can use conditional format in order to do analysis on best hitters!!
reply
Excelente, nice tool, Power Query always a marvelous! I use your steps to change format for baseball stats, changing decimal format and now I can use conditional format in order to do analysis on best hitters!!
reply
Overdraft
I thought I would watch this as review since I thought I knew what I was talking about. OK, I did know the date stuff, but then -BOOM- I can check the column quality??? Amazing. Thanks Mynda!
reply
I thought I would watch this as review since I thought I knew what I was talking about. OK, I did know the date stuff, but then -BOOM- I can check the column quality??? Amazing. Thanks Mynda!
reply
apamwamba
Thanks. Dates can be problematic.. As a rule of thumb, I usually input my dates as YYYY-MM-DD where i have control. Problem is where one does not have control. Thanks for the tip
reply
Thanks. Dates can be problematic.. As a rule of thumb, I usually input my dates as YYYY-MM-DD where i have control. Problem is where one does not have control. Thanks for the tip
reply
Mommy
Hi. I have been watching your videos to learn more about excel. And I have a question for you. Is there an east way to change data source of different pivot table at the same time?
reply
Hi. I have been watching your videos to learn more about excel. And I have a question for you. Is there an east way to change data source of different pivot table at the same time?
reply
Add a review, comment
Other channel videos
