Jogleen Caliponjworkz.hashnode.dev·Sep 10, 2024Utility Report DashboardThis sample project examines the trend of payables over the past 5 years to identify any patterns that need attention. The dataset can be found and downloaded for your reference on Kaggle Tools Used for this Project: Power Pivot, Data Modeling, Power...Discuss·30 readspowerpivot
Parth Ladthenavigatedata.com·Jun 22, 2024Avoid Repetitive Steps in MS Fabric Dataflow Gen2 with Custom FunctionsWhile working with Dataflow Gen2 or Power BI, If you keep finding yourself needing to apply the same transformations to different queries or values, making a custom function in Power Query can save you loads of time. It's like using SQL functions to ...DiscussMicrosoft FabricMicrosoft
Parth Ladthenavigatedata.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...DiscussPower QueryDataFlowGen2
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·171 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 ...Discuss·34 readsPowerQuery
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·201 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·317 readsdata analysis
