You’re offline. This is a read only version of the page.
2,013
Hi all,
I'm trying to create Aggregate Dimension for Power BI using Dynamics F&O, I'm not sure this is the right forum, but a question for development of the Aggregate Dimension.
I have a Date Dimension with one of the attribute is Month.
Question is in that property OrderBy there are 4 options :
The default is Name, but if I change to Key, what key exactly it referring to ? Is it the underlying table's Key ? what if there are multiple keys, how we select which key.
Thanks,
The order by field and Usage field work together in Aggregate entities. If you set the Order by = Key, then it's using the attribute where aggregate usage property is set to Key. You can only set one attribute to Key (you can't set multiple).
However if you set to AttributeKey instead of using attribute which is set to key, the attribute itself is used as a sorting key.
Share
Report
All responses (
Answers (
