Date Hierarchy for Quick Measure Not Working

Hi!

I think I see the source of confusion here.

You created an 'artificial' hierarchy from the field menu using some fields.

You actually have to set the property of the field in the query mode to "Date" and Power BI will create the date hierarchy for you.

Notice the icon of the field shows a calendar (indicating it's now a date field):

When you add a date field to your table, matrix, etc. It will show the 'hierarchy' by default like this (tip: click the dropdown arror to change back to actual date instead of hierarchy):

Once you use a date field, you should be able to use the time-intelligence in the quick measure.

I run into similar problem with the same setting (data source = SSAS or AAS), but it's more general.

In previous version of Power BI, I could drag any Date field, and it will expand it into Date hierarchy by default when I use Table visualization.

In the latest version (October 2018), even after enabling Show dates as a hierarchy in the field list option (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#dateHierarchy), the Date hierarchy doesn't show up at all for SSAS/AAS data source. (The setting only works for CSV data source, though)

When I try to use te Quick Measure list, it does not include any Time Intelligence category at all.  Do you have to have te PRO version in otrder to get te full list of Quick Measures?

Hi,

I am also having the same problem when attempting to use a Custom Date table in SSAS. The table is marked as a Date Table. However the hierarchy is never there.

Is there any update on this?

Thanks