Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to calculate Age in years and month in Power Query. Let’s get started In the caption below, we have our data loaded into the Power Query editor In From Date & Time group of the Add Column tab, click on Date drop-down and select Age In […]
Continue reading
Power Query: Split Date and Time into Separate Columns
Welcome to Excel Jet Consult blog. In this tutorial, we want to learn how to split Date and Time using Power Query. Let’s get started. In the caption below, we have a Date & Time data in column A with Date Format: mm/dd/yyyy Format Data as Excel Table Since we want to work with Power Query, the first thing we […]
Continue reading
Copy Sheet Between Workbooks in Excel Way
Welcome to Excel Jet Consult blog post. In this tutorial, we will see how to copy sheet from one workbook to another. Let’s get started. Usually, many users select all the cells in a sheet using CTRL + A or the Rows and Columns intersect below Name Box and execute CTRL + C. Then, in the other workbook, they execute […]
Continue reading
USERELATIONSHIP DAX Function
Welcome to Excel Jet Consult blog post. In this tutorial we want to learn how to use the USERELATIONSHIP Dax Function. Let’s get started USERELATIONSHIP Function specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and column Name2. Note, the relationship can be deployed with functions that take filter as an argument. […]
Continue reading
Import SQL Server Table Directly
Welcome to Excel Jet Consult. In this video tutorial, I demonstrated how to import table from SQL Server directly into Power Query. Enjoy the short video.Import SQL Server Table Directly from Power Query
Continue reading
Microsoft MVP from Africa Dashboard (as at Jan, 2020)
Welcome to Excel Jet Consult blog post. Happy New Year. In this video tutorial, I shown how to use Power Query, Power Pivot and PivotTable to prepare dashbaord of all active Microsoft MVP from Africa as at Jan, 2020. Do enjoy the video and subscribe to my Youtube channel for more insightful videos in 2020.
Continue reading
New Workbook Statistics in Office 365
Welcome to Excel Jet Consult blog post and Happy New Year 2020. In this post, we want to learn how to use the new Workbook Statistics made available to Office 365 users. Let’s get started The Workbook Statistics is in the Proofing group of the Review tab. The Workbook Statistics gives a summary count of cells, formulas, charts, tables, PivotTables, […]
Continue reading
Apply Custom Conditional Formatting to Clustered Column Chart in Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we will see how to apply custom conditional formatting to column chart visual. Conditional formatting enables users to easily spot trends and patterns in our data using colors, icons and bars Column Chart Conditional Formatting For this example, we want to see Sum of Amount by Month. Note, Sum of […]
Continue reading
New Quarter DAX Time Intelligence Function
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn various methods we can use to calculate standard Quarter and how to create using the new Quarter DAX function released in the Microsoft Power BI Desktop December 2019 updates. Let’s get started To use the new Quarter DAX function, we must create a calendar table because […]
Continue reading
Fixing Improper Dates in Power Query
Welcome to Excel Jet Consult blog post. In this tutorial, I will share with us how to solve the problem of improper date in Power Query. Let’s get started Quite often, I do get questions from people who have challenge of working with dataset that wasn’t correctly entered on Excel. Hence, I write this blog post to address the problem. […]
Continue reading