1 / 2

How to use Column From Examples in Power Query

Addend has successfully executed Power BI projects for 100 clients across sectors like financial services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Australia, and India. Companies partnering with us save their valuable time and efforts of searching and managing resources while saving hugely on the development costs and hence, most small and medium enterprises in North America prefer Addend to be their Power BI implementation partner. Get a free consultation now by emailing us at kamal.sharma@addendanalytics.com.

addendanalytics
Download Presentation

How to use Column From Examples in Power Query

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How to How to Use “ Use “Column Column from from Example Example” ” in Power in Power Query Query In Power BI, there are a lot of features available which helps in enhancing the reporting experience. One of those amazing features is “Column From Example”. It helps a user to create a new column based on the input entered for example. Let’s have a look at, how one can use this feature in a report! So, let’s proceed with its practical implementation… 1)Now, for example we have a “Date Column” present in our Dataset in the format of (dd/mm/yyyy) ~ 01/06/2014, but our requirement is to know about which day occurs on a particular date. For this we need to do some transformations on the “Date Column” to get the “Day of Week Names”. Let me break this process… Step-1: Open Power Query Editor window, select the “Date Column” then click on “Add Column” ribbon and from there choose “Column From Example” from selection - Step-2: When we click on the blank row of “Column1”, a small window gets open which includes all the information related to “Date Column”-

  2. Step-3: Here we select “Day of Week Name” as per our requirement from the various options available and then press Ctrl+Enter to get it applied for all the rows. Lastly click on ok option available. Now, we have a new column added into our table with all the “Day Names” related to our “Date Column”. This small yet appealing feature can help us for various report requirements. I hope your purpose must have been solved now. Thank you for reading. Addend Analytics is a Microsoft Power BI-partner based in Mumbai, India. Apart from being authorized for Power BI implementation, Addend has successfully executed Power BI projects for 100+ clients across sectors like financial services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Australia, and India. Companies partnering with us save their valuable time and efforts of searching and managing resources while saving hugely on the development costs and hence, most small and medium enterprises in North America prefer Addend to be their Power BI implementation partner. Get a free consultation now by emailing us at kamal.sharma@addendanalytics.com.

More Related