How to group data from a data model/Power Pivot

[e_nnm_m]

I have a table that shows orders. I have an order number, and open date, and and end date. This has been loaded to the data model as I use Power Pivot (and this table is linked to others.) Within the data model I have a calculated column that calculates the number of days between the open and end dates.

In an earlier version--the regular Pivot table one--I could generate a Pivot table with all the dates, and then group them so that I could create a histogram chart. But as grouping is not available in Power Pivot, I don't know what to do. Does anyone have any work arounds?

Thanks, --EM

 

[awoohaw]

I don't understand your question. I've created a dataset, added it to Power Pivot and created a calculated column of "DaysOpen":

And then created a pivot table using the data model table.

Have I missed something?

 

[e_nnm_m]

I don't understand your question. I've created a dataset, added it to Power Pivot and created a calculated column of "DaysOpen":
View attachment 114058


And then created a pivot table using the data model table.
View attachment 114059


Have I missed something?

This is exactly what I did. But now I want to group the DaysOpen by, say, a period of 10 days...so 0-10, 11-20, etc. Right-clicking on the DaysOpen shows the "group" option grayed out.

 

[e_nnm_m]

This is exactly what I did. But now I want to group the DaysOpen by, say, a period of 10 days...so 0-10, 11-20, etc. Right-clicking on the DaysOpen shows the "group" option grayed out.

It seems that what I need to do is here: Aggregations in Power Pivot - Microsoft Support

But I cannot understand how. I have tried and failed to understand DAX.

 

[e_nnm_m]

I have solved my issue. I don't like it--I don't like adding calculated columns to my data model because I am getting worried about file size--but what I did was add yet another column with an IF statement: if the days were less then or equal to 10 then 1, if the days were between 11-20 then 2, else 3. Then I was able to make a simple pivot table and column chart. By adding my own axis labels I have exactly what I needed.

If anyone knows of a more efficient way, I'd love to know. Thanks.