Parth Ladhashnode.thenavigatedata.com·Dec 4, 2023Power Query's Missing IN OperatorThe IN operator is a common feature in programming languages, allowing users to check if a value exists within a specified list. While Power Query M doesn't have a built-in IN operator, we can still achieve the same functionality using alternative me...DiscussDataFlowGen2
Nandita Kumarinandita28.hashnode.dev·Nov 29, 2023Cyclistic Bike Share AnalysisWelcome to the Cyclistic bike-share analysis case study! In this case study, I have performed many real-world tasks as a junior data analyst. I worked for a fictional company, Cyclistic. Cyclistic is a bike-share company in Chicago. The director of m...Discuss·117 readsdataanalalytics
Viraj Rathnayakavirajr.hashnode.dev·Nov 26, 2023IF Statement using Power QueryIf you're stuck with a syntax error and looking for the short answer, here it is. if Condition 1 then results if true else results if false if Condition 1 then results if true else if Condition 2 then results if false ...DiscussPowerQuery
Viraj Rathnayakavirajr.hashnode.dev·Oct 8, 2023Select the relative dates (weeks, Months, Years) from a slicer.The dates filter is the most commonly used filter in Power BI Reports. We mostly add a simple drop-down or a slicer with dates, months quarters, etc. Instead of using specific date columns for filtering some users/projects may find it useful to have ...DiscussPowerQuery
The Analyst Geektheanalystgeek.hashnode.dev·Aug 17, 2023Just Steps to Append and Merge data using Power Query in Power BIDifference between Append and Merge Merge queries can combine tables with different numbers of columns(it is simply a), while append queries require tables to have the same number of columns. Appending Files and tables in Power BI (Power Query) Appe...DiscussPowerBI
Kasturi Mukherjeekmukherjee.hashnode.dev·Jul 12, 2023Power Query in Power BI Desktop!!What is Power Query? Power Query is all about cleaning and analyzing the data. It is an ETL Service tool (Extract, Transform and Load). It allows you to import data from various sources which we call Extraction of the data and then we Transform (clea...DiscussPowerBI
Jimmy Mojimmoblog.hashnode.dev·Jun 30, 2023Power Query Dataflow - How to import Excel data into Dataverse from Power appsHave you ever been tasked with developing a canvas app that enables users to upload an Excel file and import its data into Dataverse? Even though it is a broad requirement but deal to some functional or licensing restriction in Power platform compone...Discuss·151 readspowerapps
Eniola Aboladeshocoleitt.hashnode.dev·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·355 readsdata analysis
Stephen David-Williamsstephendavidwilliams.com·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·1 like·100 readsPowerBI
Viraj Rathnayakavirajr.hashnode.dev·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...Discuss·53 readsPowerBI
