Table of Contents Let’s suppose we receive inventory files from our provider, and we need to upload these stock counts in our ERP system every time we get these files. The file format our ERP system requires is a CSV document but the file from the provider is in XLSX format. In this blog we […]
Convert Excel file to CSV format with Power Automate (xlsx to csv) Read More »
We want to analyze how invoicing works in our company, and we would like to find out which service category is the one we’re selling the most and which we could improve. So, we pull data related to all invoices we’ve sent to clients, and we find the following table: As you notice, invoice line
Lookup by keyword in DAX | Contains Logic | Power BI and Power Pivot Read More »
Power Automate has some cool out-of-the-box features to read data from Excel files. But if you want to read this data using these actions, the data needs to be formatted as an actual table in the file and not a flat range – but don’t you worry, Office Scripts got you covered! With Office scripts
Suppose we have a table with a measure such as Sum of sales amount, and we would like to give the user the ability to change the way the amounts are shown, using a slicer. The blue slicer in above example allows the user to change the Sum of sales amounts to be displayed as:
Create a slicer to change amounts to millions & thousands Read More »
Use an excel table to modify your SQL query If you regularly run queries to any database in your workplace, chances are you have encountered a user request like this: We can use Excel to query the database and get the information requested, but you will have to manually write the WHERE conditions that include
Dynamic SQL queries with Excel’s Power Query Read More »
When we connect to a folder to combine all the files, Power Query creates a “Query” called “Sample File”, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have less columns than others? In the
Power Query Files from Folder: Read More »
Combining files with Power Query is great but what happens when some unformatted files have less columns?
Learn How to Combine Tables With Slightly Different Columns Read More »
We wanted to post a small entry about this topic and explain in a very quick way, terms that may be new to some of the daily excel users.
What Is DAX and Where to Start? Read More »
