Recent searches


No recent searches

Oliver  Jacob's Avatar

Oliver Jacob

Joined Feb 16, 2023

·

Last activity Feb 16, 2023

Following

0

Follower

1

Total activity

2

Votes

0

Subscription

1

ACTIVITY OVERVIEW

Latest activity by Oliver Jacob

Oliver Jacob commented,

CommentPerforming calculations

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

  1. Create a new power query from your data table.
  2. Add custom columns and enter the formulas for getting year and month.
  3. 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