Forum Discussion
Date Hierarchy for Quick Measure Not Working
I defined a date hierarchy but the option appears greyed out and when i try to drag the columns over nothing happens..
I am not talking about the SSAS query, I am talking about the query in Power BI. If you are importing data from a data source into Power BI, it automatically creates a query where you can apply ETL.
If you aren't importing the data and instead are doing a live connection, then I am afraid there isn't anything I can help with.
Yes, its a live connection
here is the date definition in SSAS tabular