Questions tagged [customcolumn]
54 questions
0
votes
1 answer
Compare columns return maximum power query
I have data from multiple suppliers which I wish to compare. The data shown in the image below has been previously transformed via a series of steps using power query. The final step was to pivot the Supplier column (in this example consisting of…

Nick
- 789
- 5
- 22
0
votes
1 answer
Wordpress media library missing entries with NULL value when sorted after custom column
i have included 2 custom columns in the metadata of media entries called 'photographer' and 'copyright'. I have included both columns in the admin view of the media library and made them sortable. But when i sort by one of them the results exclude…

a.urbanite
- 75
- 7
0
votes
1 answer
How to add custom column for previous day sales for each product in Power Query
I have this table:
Date
Product
Sales
1/3/2021
Apple
10
1/3/2021
Lemon
20
1/3/2021
Mango
30
1/4/2021
Apple
15
1/4/2021
Lemon
25
1/5/2021
Apple
20
1/5/2021
Lemon
20
1/5/2021
Mango
35
And I want to add a new column like…

dss333
- 71
- 1
- 2
- 7
0
votes
1 answer
Making custom column in WordPress dashboard for custom taxonomy SORTABLE
I'm tearing my hair out trying to figure out what's wrong with this code. I've already read and tried every single question on this topic on StackOverflow - I'm hoping someone can spot a small bug and figure it out.
I have a custom post type called…

turtlehead
- 11
- 3
0
votes
1 answer
custom column and calculated column
i am trying to create a custom column using Mon-Year_period = FORMAT(trial[Date],"MMM-YYYY"). It gets accepted when write for custom column but when I close and apply the same, says FORMAT function error.
Also, when tried the same for calculated…

Anu
- 1
- 1
0
votes
1 answer
Answer: Laravel 7, select dynamic columns in query builder
I have spent a lot of my time to find this solution. I want to export a user selected list of columns data and here is the solution for this. The solution is getting a list of columns in array form and then I am converting it into a specific…

M Atique Khan
- 18
- 1
- 5
0
votes
3 answers
Power Query Statements for New and Repeated Order (Custom Column)
I have a Sales table consists of Date, Customer and Product columns. I want to segregate the data into two parts, New and Renew order. Each customer can order many types of products and each new product ordered by the customer will be state as New…

Aidel Ibrahim
- 29
- 8
0
votes
1 answer
Power Query - complicated custom column
I need to create a custom column which looks at 1 column, a, and based on a, trims a value from b and puts the value in c.
Part B: Now if the value in a does not match my criteria, then it looks at column d to find if it was the same as the…

Rp2019
- 1
- 2
0
votes
1 answer
Power Query: M Code for adding days (as column reference) to date
Power Query: Table:'TableABC', with columns: [Todays Date],[Additional Days].
I want to create M Code to add [Todays Date] + [Additional Days].
I keep getting an error, because [Additional Days] is a decimal number- I think. Do I need some logic to…

Josh Schaffer
- 3
- 1
0
votes
1 answer
RoRails~5: associations with custom db-field names
This question was discussed numerous times, however I run into an issue that I could not find an answer to.
I am building a login system where one Member(:class) "bails for" a new Member. Internally, they are referenced as "member" and "candidate"…

randmin
- 818
- 8
- 16
0
votes
1 answer
can we create Azure custom date column?
We have Azure AD that migrated from Windows AD
we need custom attribute(Column) in user profile as Date, such as Hire Date
is this possible? Any suggestion is appreciable
See Image

Amit Koyani
- 101
- 6
0
votes
1 answer
sharepoint: how to register eventhandlers on creation of column from Site column
I am creating a custom column type in SharePoint. This custom column requires some event handlers (like itemAdding etc.) to be registered with the list which is using this column. Now user can also create a site column of this custom column type.…

Anoop
- 5,246
- 6
- 27
- 29
0
votes
1 answer
Creating custom column type
I'm creating custom column type, and i was able to implement it on my test site. I want to learn how to add some settings/properties/configurations to this column type (sorry I'm not sure what it is exactly called for reference attaching image…

Tauha
- 99
- 1
- 12
0
votes
1 answer
Wordpress - marge – post type + custom post type + custom column in posts list
I have created one custom post type with taxonomy and it works fine.
I am going to show custom post type content in default posts list with help of “pre_get_posts” hooks and it displayed in posts list.
I need to show custom column name as “post…

Chetan Shelake
- 1
- 2
0
votes
1 answer
list all the data, merge duplicate rows and sum the total using MySQL
I have the following SQL
SELECT
i.si_num AS `id`,
DATE_FORMAT(i.si_date, '%d-%b-%Y') AS `date`,
i.si_tr AS `tr`,
d.dl_name AS `customer`,
i.si_net_value AS `net`,
DATEDIFF(CURDATE(), si_date) AS Days,
t.value AS tval,
t.label AS…

Prem
- 31
- 8