Viraj Rathnayakavirajr.hashnode.net·Feb 14, 2023Leading Zero in a month number in Power QueryNo one, absolutely no one wants to work with dates in Power Query/DAX/Power BI. But we can't avoid the date/DateTime data type as most fact tables are recorded around time and/or date. It was another day and another power query project (not a data an...DiscussPowerBI
Stephen David-Williamsspiritman7.hashnode.net·Mar 9, 2023Using Power Query to clean data in Power BIAlthough most of my data cleaning is conducted with Spark in Databricks, there are scenarios where my data doesn't need to undergo heavy transformations. If I can get my data to the output I need in just a few short steps, why not do that? In this bl...Discuss·49 readsPowerBI
Eniola Aboladeshocoleitt.hashnode.net·Apr 1, 2023FIFA-21-data-cleaning with Power QuerySource Recently, I participated in a data cleaning challenge organized on Twitter, where I had the opportunity to use Power Query for the first time. I found the experience to be both fun and challenging, and it exposed me to the capabilities of this...Discuss·153 readsdata analysis
Eniola Aboladeshocoleitt.hashnode.net·Apr 1, 2023FIFA-21-data-cleaning with Power QuerySource Recently, I participated in a data cleaning challenge organized on Twitter, where I had the opportunity to use Power Query for the first time. I found the experience to be both fun and challenging, and it exposed me to the capabilities of this...Discuss·153 readsdata analysis
Stephen David-Williamsspiritman7.hashnode.net·Mar 9, 2023Using Power Query to clean data in Power BIAlthough most of my data cleaning is conducted with Spark in Databricks, there are scenarios where my data doesn't need to undergo heavy transformations. If I can get my data to the output I need in just a few short steps, why not do that? In this bl...Discuss·49 readsPowerBI
Viraj Rathnayakavirajr.hashnode.net·Feb 14, 2023Leading Zero in a month number in Power QueryNo one, absolutely no one wants to work with dates in Power Query/DAX/Power BI. But we can't avoid the date/DateTime data type as most fact tables are recorded around time and/or date. It was another day and another power query project (not a data an...DiscussPowerBI
