custom grouping - query authoring

[_onto_]

Hi,

I was wondering if it is possible to author a query that does some aggregation using some custom grouping in a scenario where I do not have access to the model and cannot use a composite model.

For example I have a date table where I am grouping months by Season:

Summer	Jul
Summer	Aug
Summer	Jun
Fall	Sep
Fall	Oct
Fall	Nov
Winter	Dec
Winter	Jan
Winter	Feb
Spring	Mar
Spring	Apr
Spring	May

and I can do something like this:

SUMMARIZECOLUMNS('Date'[Season]
	, ROLLUPADDISSUBTOTAL('Date'[Month], "Season Total")
	, "Distinct Products", [Number of Products]
	)

to get number of products transacted by month, season and get season totals:

Season	Month	Season Total	Distinct Products
Fall	Nov	False	10
Fall	Oct	False	9
Summer	Jun	False	10
Spring	May	False	9
Fall	Sep	False	9
Winter	Jan	False	8
Spring	Apr	False	11
Summer	Aug	False	10
Spring	Mar	False	9
Winter	Feb	False	9
Winter	Dec	False	10
Summer	Jul	False	7
Spring		True	11
Winter		True	11
Fall		True	11
Summer		True	11

But what if I want to re-group my months into, say:

Drink	Month
Whatever	Nov
Whatever	Oct
Beer	Jun
Beer	May
Whatever	Sep
Wine	Jan
Beer	Apr
Beer	Aug
Beer	Mar
Wine	Feb
Wine	Dec

to get something like this:

Drink	Month	Drink Total	Distinct Products
Whatever	Nov	False	10
Whatever	Oct	False	9
Beer	Jun	False	10
Beer	May	False	9
Whatever	Sep	False	9
Wine	Jan	False	8
Beer	Apr	False	11
Beer	Aug	False	10
Beer	Mar	False	9
Wine	Feb	False	9
Wine	Dec	False	10
Beer	Jul	False	7
Beer		True	11
Wine		True	11
Whatever		True	11

Would something like this be possible through just a DAX query?

Thank you!

[lbendlin]

Not really.  Power BI does not support dynamic buckets.

Best you can do is enable "Personalize Visuals"  and teach your users how to use that awesome feature.

[_onto_]

Yeah, I was kind of thinking about it as a lineage manipulation problem. Maybe wishful thinking.