XcelanZ

  • Python
  • Power BI
    • Power Query
    • DAX
  • Excel
    • Excel Charts
    • Excel VBA
    • Excel Formulas
  • About
  • Contact
  • Python
  • Power BI
    • Power Query
    • DAX
  • Excel
    • Excel Charts
    • Excel VBA
    • Excel Formulas
  • About
  • Contact
XcelanZ

Home

Creating a 4-4-5 Calendar with Power Query

Creating a 4-4-5 Calendar with Power Query

  • Livio
  • 07, 2018
  • Excel, Power Query
  • 29 comments

Creating a 4-4-5 Calendar with Power Query 4-4-5 calendar is a common calendar structure for some industries such as retail and manufacturing. You will need to create such a calendar if you wish to harness

Read More

Power Query: Sort a Column by Another Column

Power Query: Sort a Column by Another Column

  • Livio
  • 07, 2018
  • Excel, Power Query
  • 1 comments

Power Query: Sort a Column by Another Column This is a follow-up post regarding a solution I provided on this post on Mr.Excel forum.  The OP had a table in Power Query where one of

Read More

Create a Fixed Length CSV with Power Query

Create a Fixed Length CSV with Power Query

  • Livio
  • 06, 2018
  • Excel, Power Query
  • 0 comments

Create a Fixed Length CSV with Power Query The Power Query Combiner Functions can make your life very easy when it comes to turn a table into a fixed length CSV file. The ones I

Read More

Concatenate Table Headers with First Row in Power Query

Concatenate Table Headers with First Row in Power Query

  • Livio
  • 06, 2018
  • Excel, Power Query
  • 0 comments

Concatenate Table Headers with First Row in Power Query Concatenate Table Headers with First Row in Power Query Today I found myself in the situation of dealing with a table like the one below, where

Read More

Replicate SUMPRODUCT in Power Query using List.Zip

Replicate SUMPRODUCT in Power Query using List.Zip

  • Livio
  • 06, 2018
  • Excel, Power Query
  • 1 comments

Replicate SUMPRODUCT in Power Query Today I stumbled upon the M function List.Zip which I thought would provide a valid alternative to my previous post  about replicating SUMPRODUCT in Power Query. According to Microsoft Power

Read More

Replicate SUMPRODUCT in Power Query

Replicate SUMPRODUCT in Power Query

  • Livio
  • 06, 2018
  • Excel, Power Query
  • 0 comments

Replicate SUMPRODUCT in Power Query In my previous post, MMULT in Power Query, I showed how to recreate Excel SUMPRODUCT using List.Generate. This post will show an alternative method using List.Accumulate. Power Query does not come

Read More

Replicating Excel MMULT in Power Query

Replicating Excel MMULT in Power Query

  • Livio
  • 06, 2018
  • Excel, Power Query
  • 0 comments

Replicate Excel MMULT in Power Query When you start getting into Power Query and the M language you realize the immense benefits this tool provides you with. Even the VBA geeks like myself realize that,

Read More

List and sort all Files from a folder and all subfolders using Power Query

List and sort all Files from a folder and all subfolders using Power Query

  • Livio
  • 05, 2018
  • Excel, Power Query
  • 0 comments

List all Files from a folder and all subfolders with Power Query A common task some people have is listing all files within a folder and its subfolders and then sort them by either file

Read More

Excel Clock Chart (Building one)

Excel Clock Chart (Building one)

  • Livio
  • 05, 2018
  • Excel, Excel Charts, Excel VBA
  • 0 comments

Excel Clock Chart Download the file When we look at a clock, we are looking at the first chart invented by the human kind, so why not build one in Excel? The steps are not

Read More

Animated Excel Sine Cosine Chart

Animated Excel Sine Cosine Chart

  • Livio
  • 05, 2018
  • Excel, Excel Charts, Excel VBA
  • 3 comments

Excel Animated Sine Cosine Chart While researching on the web yesterday I saw a nice animated chart showing the sine and cosine functions connected to each point of a circle which I thought would be

Read More

Post navigation

← Older posts
Newer posts →

connect with me

Search this site

Search for:

Tags

4-4-5 Calendar 4-5-4 Calendar 544 Calendar algorithms bar chart chart charts clustering collaborative filtering combinations Combiner Functions convert to roman Correlation Data Modelling data science DAX Dot Plot excel excel charts Finance Fixed Length CSV Histogram kmeans Linear Regression List.Zip M machine learning naive bayes neural networks panel chart Pareto Analysis Power BI power query Power Query Sumproduct Python Recursive Function roman Slow Changing DImensions spam filter SQL Statistics sumproduct trigonometry vba visuals
  • Legal

connect with me

XcelanZ © 2018