Oliver Jacob

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.