Are you over 18 and want to see adult content?
More Annotations
A complete backup of hurra-wir-bauen.de
Are you over 18 and want to see adult content?
A complete backup of freseniusmedicalcare.com
Are you over 18 and want to see adult content?
A complete backup of mobileguru4.blogspot.com
Are you over 18 and want to see adult content?
A complete backup of lilyallenmusic.com
Are you over 18 and want to see adult content?
A complete backup of thegbd.wordpress.com
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of fillmorecountyjournal.com
Are you over 18 and want to see adult content?
A complete backup of gullerupstrandkro.dk
Are you over 18 and want to see adult content?
A complete backup of taylorherring.com
Are you over 18 and want to see adult content?
A complete backup of cheapviagramedas.com
Are you over 18 and want to see adult content?
A complete backup of freiheitstattangst.de
Are you over 18 and want to see adult content?
A complete backup of christiancareercenter.com
Are you over 18 and want to see adult content?
Text
DINGBAT DATA
Volume loss due to tunnelling: Calculating volume loss directly from tunnel deformation in Plaxis. By camwallace Geotechnics, VBA 3 Comments. The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be,estimating
HOME – DINGBAT DATA This blog is to showcase my interests and ideas pertaining to Excel, Power BI, statistics and civil engineering. WHO’S THE DINGBAT? Who’s the dingbat? Cameron Wallace is my real name. I studied civil engineering at university and since then I have worked in mining (more specifically geotechnical engineering) and in horticulture as a data analyst. With an interest in processing data and problem solving, I’ve set up a blog to share some thoughts I have been developing. COMPOSITE KEY RELATIONSHIPS 1. fn_AddCompositeKeyMain ( {"X","Y"},"XY") We now name this function: “fn_AddCompositeKeyXY”. So, “fn_AddCompositeKeyXY” takes two parameters: a table value and a binary value. It transforms the table by inserting a new column named “XY” that concatenates columns “X” and “Y” together. Again, I do not invoke this functionCHARTICULATOR2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. REFERENCING LISTOBJECTS (TABLES) WITH VBA If you are referencing a table by its index number: For example: Scenario 1: A button that starts a macro that uses the tables on that sheet: 1. 2. 3. With Activesheet.ListObjects (1) End With. Scenario 2: Looping through a set of similar/duplicated sheets and using ListObjects (1) and ListObjects (2) on each sheet. RETAINING COLUMN TYPES IN POWER QUERY Column types in Power Query easily disappear i.e. change from type number to type any. Here are some code snippets and functions so that your column types stay intact. CREATING STATIC TABLES THAT CAN BE EDITED VIA ITS M CODE In Power BI, you can use the “Enter Data” button to manually create a table. Looking at the Power Query source code you will see a long text string (nonsensical to the human eye) that is decompressed via a function into a table. NON-AGGREGATE PIVOT WITH MULTIPLE ROWS IN POWER QUERYSEE MORE ONDINGBATDATA.COM
EXTRA DOCUMENTATION FOR SORTING FUNCTIONS AND COMPARING There are two native sort functions, List.Sort and Table.Sort. Their last argument is comparisonCriteria which can be in different styles of multiple forms. List.Sort. Order as number (Order can either be Order.Ascending ( = 0) or Order.Descending ( = 1)) TransformItem as function (this function takes a list item for its argument which itlater
DINGBAT DATA
Volume loss due to tunnelling: Calculating volume loss directly from tunnel deformation in Plaxis. By camwallace Geotechnics, VBA 3 Comments. The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be,estimating
HOME – DINGBAT DATA This blog is to showcase my interests and ideas pertaining to Excel, Power BI, statistics and civil engineering. WHO’S THE DINGBAT? Who’s the dingbat? Cameron Wallace is my real name. I studied civil engineering at university and since then I have worked in mining (more specifically geotechnical engineering) and in horticulture as a data analyst. With an interest in processing data and problem solving, I’ve set up a blog to share some thoughts I have been developing. COMPOSITE KEY RELATIONSHIPS 1. fn_AddCompositeKeyMain ( {"X","Y"},"XY") We now name this function: “fn_AddCompositeKeyXY”. So, “fn_AddCompositeKeyXY” takes two parameters: a table value and a binary value. It transforms the table by inserting a new column named “XY” that concatenates columns “X” and “Y” together. Again, I do not invoke this functionCHARTICULATOR2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. REFERENCING LISTOBJECTS (TABLES) WITH VBA If you are referencing a table by its index number: For example: Scenario 1: A button that starts a macro that uses the tables on that sheet: 1. 2. 3. With Activesheet.ListObjects (1) End With. Scenario 2: Looping through a set of similar/duplicated sheets and using ListObjects (1) and ListObjects (2) on each sheet. RETAINING COLUMN TYPES IN POWER QUERY Column types in Power Query easily disappear i.e. change from type number to type any. Here are some code snippets and functions so that your column types stay intact. CREATING STATIC TABLES THAT CAN BE EDITED VIA ITS M CODE In Power BI, you can use the “Enter Data” button to manually create a table. Looking at the Power Query source code you will see a long text string (nonsensical to the human eye) that is decompressed via a function into a table. NON-AGGREGATE PIVOT WITH MULTIPLE ROWS IN POWER QUERYSEE MORE ONDINGBATDATA.COM
EXTRA DOCUMENTATION FOR SORTING FUNCTIONS AND COMPARING There are two native sort functions, List.Sort and Table.Sort. Their last argument is comparisonCriteria which can be in different styles of multiple forms. List.Sort. Order as number (Order can either be Order.Ascending ( = 0) or Order.Descending ( = 1)) TransformItem as function (this function takes a list item for its argument which itlater
HOME – DINGBAT DATA Recent Posts. Creating static tables that can be edited via its M code; Composite Key Relationships – A better way using Power Query; Sorting by locale with comparers in multiple columns LINKS – DINGBAT DATA Links to some blogs that I enjoy: Power Query Easy to intermediate Excel on Fire: Solve problems with Oz du Soleil at his Youtube channel. Entertaining! Easy to advanced ExcelGuru.ca: Mainly PoweCHARTICULATOR2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment.GEOTECHNICS
The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be, estimating the trough width parameter (K). WHY AGILE ANALYTICS? Why Agile Analytics? – Dingbat Data. I am a consultant with Agile Analytics which is based in Sydney, Australia. I work mainly with Power BI doing both back-end and front-end work. I enjoy working with a range of people and companies who will each have their own business problems. Agile Analytics was founded by Iman Eftekhari in February2018
ZOO – DINGBAT DATA Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. SANDWICH – DINGBAT DATA Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. COFFEE – DINGBAT DATA Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment.EXCELCHUNKSSQUARE2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. ADD A BLANK QUERY IN POWER QUERY EDITOR Add a Blank Query in Power Query Editor. When accessed from Power BI Desktop: And Another way that works in both the Microsoft Excel and Power BI Desktop versions of the Power Query Editor: (Right click in the left hand queries pane to get above menu)DINGBAT DATA
Volume loss due to tunnelling: Calculating volume loss directly from tunnel deformation in Plaxis. By camwallace Geotechnics, VBA 3 Comments. The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be,estimating
HOME – DINGBAT DATA This blog is to showcase my interests and ideas pertaining to Excel, Power BI, statistics and civil engineering. WHO’S THE DINGBAT? Who’s the dingbat? Cameron Wallace is my real name. I studied civil engineering at university and since then I have worked in mining (more specifically geotechnical engineering) and in horticulture as a data analyst. With an interest in processing data and problem solving, I’ve set up a blog to share some thoughts I have been developing. COMPOSITE KEY RELATIONSHIPS 1. fn_AddCompositeKeyMain ( {"X","Y"},"XY") We now name this function: “fn_AddCompositeKeyXY”. So, “fn_AddCompositeKeyXY” takes two parameters: a table value and a binary value. It transforms the table by inserting a new column named “XY” that concatenates columns “X” and “Y” together. Again, I do not invoke this functionCHARTICULATOR2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. REFERENCING LISTOBJECTS (TABLES) WITH VBA If you are referencing a table by its index number: For example: Scenario 1: A button that starts a macro that uses the tables on that sheet: 1. 2. 3. With Activesheet.ListObjects (1) End With. Scenario 2: Looping through a set of similar/duplicated sheets and using ListObjects (1) and ListObjects (2) on each sheet. RETAINING COLUMN TYPES IN POWER QUERY Column types in Power Query easily disappear i.e. change from type number to type any. Here are some code snippets and functions so that your column types stay intact. CREATING STATIC TABLES THAT CAN BE EDITED VIA ITS M CODE In Power BI, you can use the “Enter Data” button to manually create a table. Looking at the Power Query source code you will see a long text string (nonsensical to the human eye) that is decompressed via a function into a table. NON-AGGREGATE PIVOT WITH MULTIPLE ROWS IN POWER QUERYSEE MORE ONDINGBATDATA.COM
EXTRA DOCUMENTATION FOR SORTING FUNCTIONS AND COMPARING There are two native sort functions, List.Sort and Table.Sort. Their last argument is comparisonCriteria which can be in different styles of multiple forms. List.Sort. Order as number (Order can either be Order.Ascending ( = 0) or Order.Descending ( = 1)) TransformItem as function (this function takes a list item for its argument which itlater
DINGBAT DATA
Volume loss due to tunnelling: Calculating volume loss directly from tunnel deformation in Plaxis. By camwallace Geotechnics, VBA 3 Comments. The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be,estimating
HOME – DINGBAT DATA This blog is to showcase my interests and ideas pertaining to Excel, Power BI, statistics and civil engineering. WHO’S THE DINGBAT? Who’s the dingbat? Cameron Wallace is my real name. I studied civil engineering at university and since then I have worked in mining (more specifically geotechnical engineering) and in horticulture as a data analyst. With an interest in processing data and problem solving, I’ve set up a blog to share some thoughts I have been developing. COMPOSITE KEY RELATIONSHIPS 1. fn_AddCompositeKeyMain ( {"X","Y"},"XY") We now name this function: “fn_AddCompositeKeyXY”. So, “fn_AddCompositeKeyXY” takes two parameters: a table value and a binary value. It transforms the table by inserting a new column named “XY” that concatenates columns “X” and “Y” together. Again, I do not invoke this functionCHARTICULATOR2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. REFERENCING LISTOBJECTS (TABLES) WITH VBA If you are referencing a table by its index number: For example: Scenario 1: A button that starts a macro that uses the tables on that sheet: 1. 2. 3. With Activesheet.ListObjects (1) End With. Scenario 2: Looping through a set of similar/duplicated sheets and using ListObjects (1) and ListObjects (2) on each sheet. RETAINING COLUMN TYPES IN POWER QUERY Column types in Power Query easily disappear i.e. change from type number to type any. Here are some code snippets and functions so that your column types stay intact. CREATING STATIC TABLES THAT CAN BE EDITED VIA ITS M CODE In Power BI, you can use the “Enter Data” button to manually create a table. Looking at the Power Query source code you will see a long text string (nonsensical to the human eye) that is decompressed via a function into a table. NON-AGGREGATE PIVOT WITH MULTIPLE ROWS IN POWER QUERYSEE MORE ONDINGBATDATA.COM
EXTRA DOCUMENTATION FOR SORTING FUNCTIONS AND COMPARING There are two native sort functions, List.Sort and Table.Sort. Their last argument is comparisonCriteria which can be in different styles of multiple forms. List.Sort. Order as number (Order can either be Order.Ascending ( = 0) or Order.Descending ( = 1)) TransformItem as function (this function takes a list item for its argument which itlater
HOME – DINGBAT DATA Recent Posts. Creating static tables that can be edited via its M code; Composite Key Relationships – A better way using Power Query; Sorting by locale with comparers in multiple columns LINKS – DINGBAT DATA Links to some blogs that I enjoy: Power Query Easy to intermediate Excel on Fire: Solve problems with Oz du Soleil at his Youtube channel. Entertaining! Easy to advanced ExcelGuru.ca: Mainly PoweCHARTICULATOR2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment.GEOTECHNICS
The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be, estimating the trough width parameter (K). WHY AGILE ANALYTICS? Why Agile Analytics? – Dingbat Data. I am a consultant with Agile Analytics which is based in Sydney, Australia. I work mainly with Power BI doing both back-end and front-end work. I enjoy working with a range of people and companies who will each have their own business problems. Agile Analytics was founded by Iman Eftekhari in February2018
ZOO – DINGBAT DATA Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. SANDWICH – DINGBAT DATA Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. COFFEE – DINGBAT DATA Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment.EXCELCHUNKSSQUARE2
Visit the post for more. Name: * Email Address: * Website: Save my name, email, and website in this browser for the next time I comment. ADD A BLANK QUERY IN POWER QUERY EDITOR Add a Blank Query in Power Query Editor. When accessed from Power BI Desktop: And Another way that works in both the Microsoft Excel and Power BI Desktop versions of the Power Query Editor: (Right click in the left hand queries pane to get above menu)Skip to content
DINGBAT DATA
Excel, Power BI and Civil EngineeringMenu
* Home
* Links
* Who’s the dingbat? * Why Agile Analytics?* Simple How To
* Add a Blank Query in Power Query Editor__
January 6, 2019
COMPOSITE KEY RELATIONSHIPS – A BETTER WAY USING POWER QUERY__By camwallace
__Power Query __ 0Comments
Concatenation for composite key relationships can be done a betterway!
Read More
June 7, 2018
SORTING BY LOCALE WITH COMPARERS IN MULTIPLE COLUMNS__By camwallace
__Power Query __ 0Comments
Lists can be easily sorted using comparer functions, but sorting table column(s) with comparer functions is much more difficult. This post introduces a function that allows you to do this. One major reason to use this function is for sorting according to the rules of a specific language or locality.Read More
May 31, 2018
EXTRA DOCUMENTATION FOR SORTING FUNCTIONS AND COMPARING FUNCTIONS INPOWER QUERY
__By camwallace
__Power Query __ 0Comments
Extra documentation for the native sort functions and comparers. It also gives some background information to a custom function I will introduce in the next post.Read More
April 28, 2018
RETAINING COLUMN TYPES IN POWER QUERY__By camwallace
__Power Query __ 4Comments
Column types in Power Query easily disappear i.e. change from type number to type any. Here are some code snippets and functions so that your column types stay intact.Read More
March 8, 2018
NON-AGGREGATE PIVOT WITH MULTIPLE ROWS IN POWER QUERY__By camwallace
__Power Query __ 7Comments
How to perform a non-aggregate pivot when there are multiple values under the same criteria.Read More
November 24, 2017
REFERENCING LISTOBJECTS (TABLES) WITH VBA__By camwallace
__VBA __ 3 Comments This is about how to the reference a table and its columns in VBA (where it is known as a ListObject) in a multitude of scenarios. The aim is to make your VBA code robust for the situations where a table name, column name or column position is liable to change.Read More
November 19, 2017
VOLUME LOSS DUE TO TUNNELLING: CALCULATING VOLUME LOSS DIRECTLY FROM TUNNEL DEFORMATION IN PLAXIS__By camwallace
__Geotechnics , VBA
__ 2 Comments
The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be, estimating the trough width parameter (K). A link to the spreadsheet can be found at the top of the blog post.Read More
DINGBAT DATA
This blog is to showcase my interests and ideas pertaining to Excel, Power BI, statistics and civil engineering.SEARCH
RECENT POSTS
* Composite Key Relationships – A better way using Power Query * Sorting by locale with comparers in multiple columns * Extra documentation for Sorting Functions and Comparing Functionsin Power Query
* Retaining column types in Power Query * Non-aggregate pivot with multiple rows in Power QueryCATEGORIES
* Geotechnics
* Power Query
* VBA
YOU CAN ALSO FIND ME HERE*
*
*
SEARCH
Dingbat Data Copyright © 2019. Theme by MyThemeShop . Back to Top ↑Follow this blog!
Get the latest posts delivered to your mailbox:Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0