Recent searches
No recent searches

Oliver Jacob
Joined Feb 16, 2023
·
Last activity Feb 16, 2023
Following
0
Follower
1
Total activity
2
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Oliver Jacob
Oliver Jacob commented,
Dane your suggestion for grouping orgnazations worked like a champ. I am now stuck on how to report on month and year combined in a calculated attribute. In this article it says it will sort them alphabetically - is there any way around that?
- Sort like time attribute: If your calculated attribute represents dates, this option places your date values in the correct order.
- Note: This option applies only to single attributes. Combining attributes, such as adding a year to the end of a month, will result in sorting alphabetically instead of chronologically.
With the below formula, you can concatenate year, month and day to date in Excel. 1. Select a blank cell to place the concatenated date, and enter formula =A2&"/"&B2&"/"&C2 into the formula bar, then press the Enter key
- Create a new power query from your data table.
- Add custom columns and enter the formulas for getting year and month.
- Optional: you can enter the steps directly into the advanced editor (shown at the end of this post).
Select the cells you want to format. Press CTRL+1. In the Format Cells box, click the Number tab. In the Category list, click Date, and then choose a date format you want in Type.
View comment · Posted Feb 16, 2023 · Oliver Jacob
0
Followers
0
Votes
0
Comments